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

124 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
edge6571968(None) 
edged85514531edged
edger75215951edger
edges75718741edges
edgy94713531edgy
hedge105317351hedge
kedge115513741kedge
ledge76519491ledge
sedge75019971sedge
wedge105215661wedge
adage7414052adage
adze1412820572adze
age47154332_age
badge94819692badge
beige81515382beige
budge94619882budge
cadge94018792cadge
cage75339062cage
cede74928782ced_e
de37049552_d_e
dee47665822_dee
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
dere56845902dere
die46759662_die
dodge86618132dodge
doe47361952_doe
doge66233802doge
dredge9308562dredge
due45249862_due
dye75334842_dye
eager65526972eager
eagle64219482eagle
eagre64315322eagre
ease45042332ease
eave75733582eave
eche97520282eche
ed38645192ed__
eddo63411812eddo
eddy93912102eddy
edgers84413922edgers
edgier8469732edgier
edh76921572ed_h
edhs86212102edhs
edile64819492edile
edit54934872edit
eds46638932ed_s
educe84313452educe
eger55923572e_ger
egg56918672e_gg
egged85114392egged
egger74414412egger
eggs66516152eggs
eggy96611852eggy
ego46726052e_go
eide55832252eide
eke75630092e_ke
else45923082else
eme55837182e_me
endue64215352endue
eng46726782eng_
engs56121392engs
epee64628502epee
ere36352772e_re
erg45531072erg_
ergo56420152ergo
ergs55523812ergs
erne46727432erne
esne47018792esne
eve66331162e_ve
ewe66630982e_we
eye65539772e_ye
eyne76322462eyne
eyre75525252eyre
fadge104817002fadge
fidge104516072fidge
fledge11439312fledge
fudge105315532fudge
gage65936102gage
hedged125211812hedged
hedger114912652hedger
hedges115016262hedges
hedgy134510752hedgy
henge94819832henge
huge86321652huge
idle55423772idle
judge144714162judge
kedged13439752kedged
kedges124812982kedges
ledger85914392ledger
ledges84918012ledges
ledgy105712022ledgy
lodge76520092lodge
loge56837192loge
luge55531642luge
mage75739132mage
merge84523692merge
midge95016562midge
nudge74616432nudge
ode47446592od_e
page76036102page
peage84723572peage
pledge10469492pledge
rage55742352rage
rede55037682red_e
redye94413472redye
ridge75018682ridge
sage55044592sage
sedges83817812sedges
sedgy104512792sedgy
serge64727472serge
sledge85011302sledge
tenge65720452tenge
urge54722422urge
venge95117992venge
verge93419842verge
wage84834082wage
wedged125110302wedged
wedges114614582wedges
wedgie11428372wedgie
wedgy13479802wedgy
wodge107212932wodge

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 Filter178691298720.326548131.9
2DLD Change Limit298721240.97030795.9
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.326134759.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.