Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “foh” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

350 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
foh9813589(None) 
feh96136091feh
fob86748331fob
foe66350811foe
fog76945561fog
fohn106116551fohn
fon66352271fon
fop86743701fop
for66952071for
fou66743781fou
fox136737861fox
foy96044261foy
noh66640641noh
oh57447001_oh
ooh67637091ooh
poh86740531poh
aah616252962aah
ah513868792_ah
ash67944602ash
bah87755352bah
bo410957572bo_
boa56954032boa
bob76755662bob
bod67055542bod
bog67852412bog
boho96923322boho
boo58163662boo
bop77549482bop
bos57966812bos
bosh96328972bosh
bot59680402bot
both96533432both
bow87051902bow
box1210142342box
boy87753562boy
cob710258752cob
cod69660122cod
cog69552902cog
coho97524492coho
col59360352col
con510268022con
coo59566362coo
cop711162372cop
cor59960942cor
cos510270392cos
cosh96127622cosh
cot510483222cot
cow89856712cow
cox1210346782cox
coy810557552coy
coz149345362coz
dah78148982dah
do310155252do_
doc66841512doc
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
doth86225712doth
dow76749972dow
duh77930382duh
edh76921562edh
eh58339962_eh
eon36052082eon
eth66630982eth
fa510148452f_a
fab87453132fab
fad77452412fad
fag76852362fag
fan67158852fan
far67762602far
fas68262932fas
fash107232292fash
fat68178082fat
fax138143312fax
fay97454862fay
fe57944742f_e
fed76548352fed
fee66862012fee
fehs106522382fehs
fem86040732fem
fen66851352fen
feod815523002feod
fer66646122fer
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fey95940882fey
fez156236822fez
fib86344262fib
fid76847682fid
fie67152442fie
fig76242832fig
fil65447142fil
fin66458032fin
fir66744892fir
fish106926272fish
fit66365452fit
fix136236102fix
fiz156238762fiz
floc95922122floc
floe76129772floe
flog85523892flog
flop96925452flop
flow105924922flow
flu66530212flu
fly97124952fly
foal76630922foal
foam97127172foam
fobs96034272fobs
foci94521002foci
foehn11236322foehn
foes76543442foes
fogs87035002fogs
fogy115923182fogy
fohns117310782fohns
foil76433912foil
foin77231562foin
fold86528942fold
folk116021542folk
fond86330952fond
fons76943892fons
font77143752font
food86830572food
fool75330592fool
foot76248012foot
fops96532682fops
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
forth116222672forth
foss76431642foss
foul77027582foul
four76226862four
fowl105723632fowl
foxy176517752foxy
foys105628292foys
fozy197017162fozy
fro65530642fro
froe75329992froe
frog85624362frog
from96923922from
frosh115713402frosh
froth115919282froth
frow106425052frow
fry96226502fry
fub86337392fub
fud76335152fud
fug76234512fug
fun66841142fun
fur66637322fur
go38748742go_
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
gor47848262gor
gos47155132gos
gosh86123422gosh
got49870442got
goth86825082goth
gox117137182gox
goy77844552goy
hah910655222hah
heh96039622heh
ho510258272ho_
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
hoy97447912hoy
huh96432012huh
ich86227742ich
ion36051022ion
jo99539602jo_
job128041772job
joe106642352joe
jog117438312jog
john145512902john
josh145117612josh
jot108259022jot
jow137639302jow
joy137036362joy
koa76737772koa
kob99442382kob
kohl113911712kohl
koi77534742koi
kop97440202kop
koph135816542koph
kor76538892kor
kos76944822kos
lo28053442lo_
lob57154462lob
loch95527132loch
log46252682log
loo38359822loo
lop58255312lop
lot38179262lot
loth76132132loth
low66051872low
lox108240962lox
mho86624622mho
mo49158482mo_
moa57249182moa
mob78651912mob
moc77845082moc
mod69054402mod
mog66949672mog
mol56654592mol
mom78853162mom
mon57561572mon
moo58460512moo
mop76950822mop
mor56855002mor
mos57067122mos
mosh95227602mosh
mot57279422mot
moth96731332moth
mow86650352mow
nah69847002nah
no29353242no_
nob58954422nob
nod47549562nod
nog46847312nog
nom510450642nom
noo37154042noo
nor38048822nor
nos38859322nos
nosh76223542nosh
not39474662not
now65950192now
nth66320592nth
od39255242_od
oe28473062_oe
of58247772_of
off96331632off
oft67744062oft
ohm86523012_ohm
oho66534382_oho
ohs66232312_ohs
oi29061482_oi
om48553002_om
on28057182_on
oohs75220692oohs
oot311274692oot
op45850162_op
or27354732_or
os211359882_os
ow58950172_ow
ox98242382_ox
oy58950132_oy
pah88853592pah
peh86740962peh
pod66351482pod
poi57244662poi
pol56449382pol
pom78249912pom
poo57757112poo
pooh96027382pooh
pop76252252pop
posh95427322posh
pot58078432pot
pow87147282pow
pox126140692pox
qoph185911942qoph
rah68052402rah
rho65924832rho
rob56754302rob
roc520243252roc
rod47953892rod
roe36861072roe
rom59855632rom
rot37282952rot
row67453672row
sh56828522_sh
shh97121072shh
so28855442so_
sob57857942sob
sod46053702sod
sol37256622sol
som59153802som
son37761952son
sop57557862sop
soph97024202soph
sos37761602sos
sot310384292sot
soth75932512soth
sou37853692sou
sow66554762sow
sox106444192sox
soy67851452soy
tho67433962tho
to218858982to_
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
too38965422too
top510560682top
toph96326872toph
tor39261682tor
tosh74826812tosh
tot38884772tot
tow610557362tow
toy69655192toy
ugh76520682ugh
uh57429852_uh
voe67739052voe
vow96136312vow
vox136628152vox
who95526772who
wo510447762wo_
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
yah99046352yah
yeh97135772yeh
yo59748552yo_
yob87945272yob
yod77545502yod
yodh119916102yodh
yogh116616142yogh
yok107335242yok
yom88043442yom
yon67348952yon
you66641822you
yow96945292yow
zoa128529992zoa
zoo126238912zoo

Search took 1 second overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691140840.0632836365.1
2DLD Change Limit140843500.39335837.2
3Display Results3503500.0605833.3
 (SQL Overall)1786913500.516346300.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.