© 2026 Hedgehog Software, LLC
SELECT show_trgm('res'), show_trgm('very interesting place'), similarity('res', 'very interesting place');
# show_trgm show_trgm similarity 1 {" r"," re","es ",res} {" i"," p"," v"," in"," pl"," ve",ace,"ce ",ere,ery,est,ing,int,lac,"ng ",nte,pla,res,"ry ",sti,ter,tin,ver} 0.03846154
SELECT show_trgm('面白い'), show_trgm('とても面白い場所'), similarity('面白い', 'とても面白い場所');
# show_trgm show_trgm similarity 1 {} {} 0
show_trgm show_trgm similarity {0xb55e8b,0xc4530f,0x0b774a,0x74c091} {0x9176bd,0x920e92,0x960770,0xbe019e,0xed92a2,0xf9c014,0x14dccf,0x6fc655,0x74c091} 0.083333336