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

175 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
emus6682168(None) 
amus65529611amus
ecus65421461ecus
emes65434661emes
emeus76913331emeus
ems56435491em_s
emu55929981emu_
mus55946751_mus
amas67746292amas
amis66445322amis
amps86230342amps
amu58237322amu_
amuse75920832amuse
anus47131112anus
beaus75127112beaus
bemas96424282bemas
bemuse1038942bemuse
bums85934592bums
bus56950972_bus
crus65828482crus
demes86032692demes
demos86022992demos
demur8311162demur
demurs939772demurs
ears46356592ears
eats47054872eats
eau37450942eau_
eaux116618422eaux
ebbs82411992ebbs
ecrus75113862ecrus
ecu56828232ecu_
edhs86212102edhs
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
em49445152em__
eme55837182em_e
emeu66723432emeu
emic86422752emic
emir65918702emir
emirs76116162emirs
emit65438422emit
emits75421472emits
emmy116013242emmy
emmys12446022emmys
emyd1047072emyd
emyds1144922emyds
ends56528522ends
engs56121392engs
ens37245922e_ns
enuf7323842enuf
eons46638712eons
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428232erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
etui45416232etui
etuis54013132etuis
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
femes105626222femes
fems96428702fem_s
femur1038682femur
femurs1136712femurs
fetus85816542fetus
feus75830752feus
flus75626542flus
gems75329112gem_s
genus65319832genus
geums85414112geums
gnus56518002gnus
gums75030942gums
hemes105031082hemes
hemps126917332hemps
hems95534942hem_s
hums96831422hums
humus106215072humus
imps86221122imps
jehus15488572jehus
jus106930222_jus
kemps135012522kemps
lemur739772lemur
lemurs837252lemurs
lums65734242lums
mas58175822_mas
meds75735362meds
megs75530632megs
mels65941532mels
memes94927702memes
memos95719112memos
mems85931502mems
menus75822842menus
meous76120062meous
mess65932432mess
mews96629332mews
mis58162622_mis
momus96116112momus
mos57067122_mos
mu46737482_mu_
mud67336862_mud
muds75530652_muds
mug65837692_mug
mugs76232042_mugs
mum76643612_mum
mums85732772_mums
mumus95517282mumus
mun56143862_mun
muns65535922_muns
muse67136032_muse
mush94929122_mush
musk104526192_musk
muss64933762_muss
must65145442_must
mut58357182_mut
muts64839982_muts
negus64513562negus
nemas75321572nemas
neums75414252neums
nevus84611392nevus
nexus124710662nexus
nous46136982nous
nus37939392_nus
oms56337512om_s
onus45826812onus
opus66420592opus
plus66324832plus
pus55547842_pus
ramus76418282ramus
rebus75721112rebus
rems66237722rem_s
rhus75114052rhus
rums64833472rums
semes75731582semes
semis74623532semis
smug75815262smug
smush104410582smush
smut66629782smut
smuts75415712smuts
sous46947212sous
sums65837582sums
taus46342732taus
temps95417132temps
thus76721472thus
ulus45622562ulus
umps85721942umps
urus46426142urus
us26937432__us
vaus75928922vaus
venus84918902venus
wamus105514682wamus
xerus12313332xerus
yous76230652yous
zebus164610052zebus

Search took 6 seconds 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 Filter178691298721.313136093.7
2DLD Change Limit298721753.7507965.9
3Display Results1751750.0463804.3
 (SQL Overall)1786911755.10934975.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.