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

195 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
mho8662462(None) 
ho510258271_ho
mhos95517771mhos
mo49158481m_o
moo58460511moo
oho66534381oho
rho65924831rho
tho67433961tho
who95526771who
abmho1236792abmho
abo59045962abo
ado49146872ado
ago48845522ago
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
ambo88225142ambo
ammo85520132ammo
apo511142122apo
avo68936232avo
azo128233392azo
bio57846082bio
bo410957572_bo
boho96923322boho
boo58163662boo
bro56236602bro
chao95727312chao
chi86228652chi
chon96627792chon
chop116024922chop
chow125820992chow
coho97524492coho
coo59566362coo
dhow116614002dhow
do310155252_do
duo48536142duo
echo96615952echo
ego46726052ego
eh58339962eh_
foh98135892foh
fro65530642fro
ghi77019882ghi
go38748742_go
goo47754772goo
ha510259942_ha
hao67251122hao
he58151952_he
hi57947582_hi
hm78126732_hm
hmm106218992hmm
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776062_hot
how97252432_how
hoy97447912_hoy
jo99539602_jo
khi106318302khi
lo28053442_lo
loo38359822loo
ma410060662m_a
mac78053932mac
macho126120152macho
mad68958712mad
mae57659112mae
mag67956482mag
mahoe10315572mahoe
mako105622362mako
man57465872man
mano66536812mano
map77255122map
mar57965952mar
mas58175822mas
mat58083942mat
maw87050102maw
max129045452max
may88757632may
mayo96524302mayo
me47748332m_e
med66146742med
meg66040952meg
mel56047482mel
mem77943472mem
memo85924792memo
men59252852men
meno66031362meno
meou65325862meou
meow95117882meow
met56072432met
mew86137732mew
mi48249052m_i
mib76946122mib
mic77647642mic
mid67354472mid
mig65646082mig
mil55752112mil
milo65536102milo
mim76048422mim
mir57046772mir
mis58162622mis
miso67229902miso
mix126138182mix
mm67826812m_m
moa57249182moa
mob78651922mob
moc77845082moc
mod69054402mod
mog66949672mog
mojo136917222mojo
mol56654592mol
mom78853162mom
mon57561582mon
mono66036722mono
mood76332062mood
mool67533862mool
moon67140812moon
moor66628552moor
moos66051302moos
moot67653622moot
mop76950822mop
mor56855002mor
mos57067122mos
mot57279422mot
mow86650352mow
mozo157719742mozo
mu46737482m_u
mucho125013442mucho
mud67336862mud
mug65837692mug
mum76643612mum
mun56143862mun
muon65722732muon
mus55946752mus
mut58357182mut
my78125652m_y
myc106519502myc
no29353242_no
noh66640642noh
noo37154042noo
oh57447002oh_
ohm86523012ohm
ohs66232312ohs
ono36838032ono
ooh67637092ooh
oxo107322962oxo
phi86524202phi
phon95925382phon
phot95534362phot
pht86030522pht
poh86740532poh
poo57757112poo
pro55837262pro
rhos76319062rhos
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shmo95318102shmo
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
show106229192show
shy96728192shy
so28855442_so
tao38358952tao
the67436052the
thio77225412thio
thou76722212thou
thro77726422thro
thy97022912thy
to218858982_to
too38965422too
two67925832two
udo49027302udo
uh57429852uh_
umbo85516662umbo
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 Limit140841950.39036112.8
3Display Results1951950.0335909.1
 (SQL Overall)1786911950.689259348.3
 
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.