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 “darneder” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
darneder103398(None) 
damneder1243761damneder
durneder1043231durneder
dander811222992da_n_der
darkener1335992darkener
darned85018482darned__
darnedest1145252darnedest
darner74017302darn__er
daunder9348902daun_der
acceder1235373_acceder
amender10349613_amender
arider74717743_ar_ider
bander93928223ba_n_der
barned95623583barned__
barnier93213673barn_ier
barrener1038343barrener
bartender1244613bartender
barterer102711653barterer
brander103915823bran_der
breeder103210043_breeder
calender1138273calender
carder94524183car__der
careener1039333careener
career85822243car_e_er
careerer1038583careerer
curseder1145343curseder
daintier937403daintier
damned104212913damned__
damnedest1344333damnedest
damner95213433damn__er
dampener1335533dampener
dancer94817613da_n_cer
danders93921183da_n_ders
dandier93714573da_ndier
dandler94414273da_ndler
danger83722833da_n_ger
dangler96912813da_ngler
danker114319663da_n_ker
dapperer1335763dapperer
dared75935013dar_ed__
darer65230793dar___er
darked123919633darked__
darkened1435943darkened
darkeners1435163darkeners
darker114718693dar__ker
darklier1335013darklier
darndest1067223darndest
darnedests1242233darnedests
darnel74312183darn__el
darnels83710433darne_ls
darners83815773darne_rs
darted84620923darted__
darter75320363dar__ter
daunders10278483daun_ders
daunter83811753daun_ter
dawned113912093dawned__
defender1337293defender
degender1136893degender
denuder9167603d_enuder
derider93214973der_ider
dernier83011943dern_ier
dredger10347453d_r_edger
durned84113173durned__
durnedest1144083durnedest
earned74818333earned__
earner63617223earn__er
gander84322763ga_n_der
gardener1037113gardener
garner73917003garn__er
garnered10247123garnered
grander93315873gran_der
hander104526433ha_n_der
hardener1238883hardener
harder105022403har__der
harkener1537573harkener
jaggeder1842783jaggeder
lander74028493la_n_der
larcener1036493larcener
larder73720973lar__der
launder8309153laun_der
lavender1235143lavender
marauder1144553marauder
marketer1437383marketer
maunder10328693maun_der
nakeder1254363na_keder
pander93725533pa_n_der
parader103914863par_ader
parcener1238473parcener
parleyer1335633parleyer
raggeder1143263raggeder
render74024143__render
sander74828533sa_n_der
scareder1135793scar_eder
tireder837703tir_eder
wander104423713wa_n_der
warder104020273war__der
warned104018913warned__
warner93717223warn__er
warrener1136923warrener
yarder103813973yar__der
yarned105514023yarned__
yarner93313063yarn__er
zander163417113za_n_der

Search took 9 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621037.69019006.8
3Display Results1031030.0303433.3
 (SQL Overall)1786911038.17321863.6
 
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.