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

127 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
edges7571874(None) 
edge65719681edge_
edged85514531edged
edger75215951edger
edgers84413921edgers
hedges115016261hedges
kedges124812981kedges
ledges84918011ledges
sedges83817811sedges
wedges114614581wedges
adages8412952adages
adzes155913802adzes
aedes64625152aed_es
ages55844592_ages
badges103917372badges
beiges91014412beiges
budges104820132budges
cadges104716712cadges
cages85936012cages
cedes84927332ced_es
dees56356632_dees
degas75119162degas
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dies55653522_dies
dodges96119082dodges
does56554472_does
doges75630162doges
dredges10379352dredges
dues56045502_dues
dyes85331892_dyes
eager65526972eager
eagers74523682eagers
eagles73819162eagles
eagres74014572eagres
eases56041612eases
eaves85231992eaves
eches106322162eches
eddies83313162eddies
eddoes8199142eddoes
edgier8469732edgier
edgiest92310352edgiest
edgy94713532edg_y
edhs86212102ed_hs
ediles74016982ediles
edits65819032edits
eds46638922ed__s
educes94011952educes
eger55923572e_ger
egers65120372e_gers
egest65222342e_gest
egged85114392egged
egger74414412egger
eggers84612582eggers
eggs66516152e_ggs
egis56520652e_gis
egos55821652e_gos
ekes86726602e_kes
elves85118742elves
emes65434662e_mes
endues73813902endues
engs56121392eng_s
epees75219832epees
ergs55523812erg_s
ernes55224812ernes
erses55826802erses
eses45336102e_ses
esnes54817362esnes
esses56422972esses
eves76230462e_ves
ewes76328702e_wes
exes116530812e_xes
eyes75837882e_yes
eyres84921772eyres
fadges114814032fadges
fidges114114392fidges
fledges12409392fledges
fudges114314502fudges
gages74529972gages
hedge105317352hedge_
hedged125211812hedged
hedger114912652hedger
hedgers124310262hedgers
henges104516462henges
ides57734232id_es
idles66720122idles
judges153713462judges
kedge115513732kedge_
kedged13439752kedged
ledge76519492ledge_
ledger85914392ledger
ledgers94912182ledgers
leges64427292leges
lodges86820152lodges
loges66534202loges
luges65928752luges
mages85036022mages
merges94122492merges
midges103516482midges
nudges84114742nudges
odes57243242od_es
pages85235072pages
peages94321852peages
pedes85327292ped_es
pledges113811582pledges
rages64539442rages
redes65139132red_es
redoes74623772redoes
redyes104214092redyes
reges65628792reges
ridges85817012ridges
sages65339062sages
sedge75019972sedge_
serges74225972serges
sledges94511572sledges
urges64619912urges
veges94118872veges
venges104015152venges
verges104320182verges
wages95330932wages
wedge105215662wedge_
wedged125110302wedged
wedgies123910212wedgies
wodges117413682wodges

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001271.37339184.3
3Display Results1271270.0333848.5
 (SQL Overall)1786911271.719103950.6
 
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.