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

158 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
edh7692156(None) 
ed38645181ed_
edhs86212101edhs
eds46638921eds
eh58339961e_h
eth66630981eth
aah616252962aah
ad311975032ad_
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
ah513868792_ah
ash67944602ash
bah87755352bah
bed67950622bed_
beds75937782beds
bedu75923692bedu
beth96629232beth
cede74928762cede
cedi74919272cedi
dah78148982dah
de37049542_de
deb66342692deb
dee47665822dee
def76546722def
del46752752del
den47554342den
dev76033772dev
dew77139922dew
dex116936882dex
dey77243372dey
do310155252_do
duh77930382duh
each95530582each
ear36867882ear
eat36989052eat
eath75735662eath
eau37450942eau
ebb72418632ebb
eche97520282eche
echo96615952echo
echt95722902echt
ecu56828232ecu
eddo63411802eddo
eddy93912092eddy
edge65719662edge
edgy94713522edgy
edit54934862edit
eek77935102eek
eel37946842eel
ef57345362e_f
eff96128622eff
efs66829602efs
eft66038822eft
egg56918672egg
ego46726052ego
eide55832232eide
eke75630092eke
el26745292e_l
eld46733792eld
elds56324852elds
elf66138522elf
elhi7612402elhi
elk76726122elk
ell36735682ell
elm57531742elm
els37645722els
em49445152e_m
eme55837182eme
ems56435492ems
emu55929982emu
en28052392e_n
end46834352end
ends56528522ends
eng46726782eng
ens37245922ens
eon36052082eon
epha9310052epha
er28345142e_r
era35741502era
ere36352772ere
erg45531072erg
ern35738352ern
err35626532err
ers36046282ers
es29048222e_s
ess36030882ess
et26964192e_t
eta35834192eta
etch95419142etch
eths76619522eths
eve66331162eve
ewe66630982ewe
ex98835642e_x
eye65539772eye
fed76548352fed_
feds85234312feds
feh96136092feh
foh98135892foh
ged57044532ged_
geds66730812geds
hah910655222hah
heh96039622heh
heth107028022heth
huh96432012huh
ich86227742ich
id38941832id_
ids47535462ids
lech96825442lech
led46254552led_
med66146742med_
meds75735362meds
mesh96823002mesh
meth95827842meth
nah69847002nah
noh66640642noh
nth66320592nth
od39255242od_
oda48133042oda
odah87018932odah
odd57725452odd
ode47446582ode
ods47546212ods
oh57447002_oh
ooh67637092ooh
pah88853592pah
pech116125452pech
ped66751522ped_
peds75835242peds
peh86740962peh
poh86740532poh
rah68052402rah
red46755802red_
redd66323172redd
rede55037662rede
redo56029362redo
reds56042862reds
resh76523452resh
sh56828522_sh
shh97121072shh
sidh86222982sidh
tech95925442tech
ted46446562ted_
teds54932572teds
teth76327892teth
udo49027302udo
ugh76520682ugh
uh57429852_uh
wed75843622wed_
weds86628932weds
yah99046352yah
yeah106725412yeah
yech127220532yech
yeh97135772yeh
yodh119916102yodh
zed135431172zed_
zeds145821802zeds

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.0602978183.3
2DLD Change Limit140841580.40634689.7
3Display Results1581580.0334787.9
 (SQL Overall)1786911580.499358098.2
 
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.