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 “oho” 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.

225 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
oho6653438(None) 
boho96923321boho
coho97524491coho
ho510258271_ho
mho86624621mho
oh57447001oh_
ohm86523011ohm
ohs66232311ohs
ono36838031ono
ooh67637091ooh
oxo107322961oxo
rho65924831rho
tho67433961tho
who95526771who
abo59045962abo
ado49146872ado
ago48845522ago
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
apo511142122apo
avo68936232avo
azo128233392azo
bio57846082bio
bo410957572_bo
bohos105618252bohos
bolo65535952bolo
boo58163662boo
boyo96923842boyo
bozo156821412bozo
bro56236602bro
chao95727312chao
chi86228652chi
chon96627792chon
chop116024922chop
chow125820992chow
coco87330602coco
cohog117813042cohog
cohos105921852cohos
coo59566362coo
dhow116614002dhow
do310155252_do
dodo66024912dodo
dojo126016142dojo
duo48536142duo
echo96615952echo
ego46726052ego
eh58339962eh_
foh98135892foh_
fohn106116552fohn
fro65530642fro
ghi77019882ghi
go38748742_go
gobo76126902gobo
gogo69722832gogo
goo47754772goo
ha510259942_ha
hao67251122hao
he58151952_he
hi57947582_hi
hm78126732_hm
hob87550922hob
hobo97026082hobo
hod76852462hod
hoe67562722hoe
hog78049062hog
homo96126472homo
hon67759382hon
hood85132332hood
hoof106036582hoof
hook116133282hook
hoop96129982hoop
hoot75752102hoot
hop87554592hop
hos68364192hos
hot67776062hot
how97252432how
hoy97447912hoy
jo99539602_jo
john145512902john
khi106318302khi
kobo107422102kobo
kohl113911712kohl
kolo87026222kolo
koto86323472koto
lo28053442_lo
lobo67229862lobo
loco67030742loco
logo57931762logo
loo38359822loo
mhos95517772mhos
mo49158482_mo
mojo136917222mojo
mono66036722mono
moo58460512moo
mozo157719742mozo
no29353242_no
noh66640642noh_
nohow1137292nohow
nolo46229312nolo
noo37154042noo
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oboe66822942oboe
obol65220612obol
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
odor55718092odor
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
ohed87825182ohed
ohia75719362ohia
ohms95514032ohms
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
old47033462old
ole37155212ole
oleo46630482oleo
olio46829672olio
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
onos46229002onos
ons36148512ons
onto46127662onto
oohs75220692oohs
oot311274692oot
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orb55736862orb
orc57034922orc
ordo54622352ordo
ore36661832ore
ors35750112ors
ort39465232ort
ortho8312292ortho
orzo134516782orzo
os211359882o_s
ose38147342ose
otto45220642otto
oud47439072oud
our36042892our
out38072152out
ouzo133516932ouzo
ova66823792ova
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxy136320982oxy
oy58950132o_y
phi86524202phi
phon95925382phon
phot95534362phot
pht86030522pht
poco86826152poco
poh86740532poh_
polo66236632polo
pomo85828452pomo
poo57757112poo
pooh96027382pooh
pro55837262pro
rhos76319062rhos
roto45935052roto
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shmo95318102shmo
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
show106229192show
shy96728192shy
so28855442_so
solo45538942solo
tao38358952tao
the67436052the
thio77225412thio
thou76722212thou
thro77726422thro
thy97022912thy
to218858982_to
too38965422too
topo66932402topo
toro48045682toro
toyo76925452toyo
two67925832two
udo49027302udo
uh57429852uh_
upo58925862upo
wha96422072wha
whoa106615202whoa
whom127018182whom
whop125520922whop
why126920012why
wo510447762_wo
woo66949802woo
yo59748552_yo
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.266671770.7
2DLD Change Limit140842250.34341061.2
3Display Results2252250.0464891.3
 (SQL Overall)1786912250.655272810.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.