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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
deodands114460(None) 
deodand1035711deodand_
dedans85915072de_dan_s
demands114311412de_mands
deodaras1044692deodaras
deodars937622deoda_rs
desands94810162de_sands
doodads1035092dooda_ds
deadens93410693deaden_s
deadpans12205173deadpan_s
deads75726913de__a_ds
deans66131393de__an_s
debeards1235503debeards
decanes103118913de_canes
decants103514443de_cants
deckhands2043083deckhands
deewans11306903deewan_s
defangs1235363de_fangs
defends12358773de_fends
defrauds1343243defrauds
defunds12376753de_funds
deleads9379703delea_ds
demand104314253de_mand_
demeans1039723demean_s
deodar837713deoda__r
deodara945243deoda_ra
deodorants1252933deodorants
depends11348993de_pends
deplanes11311213deplanes
desand84812633de_sand_
descants112910143descants
descends12266983descends
desmans1039003desman_s
desponds1246243desponds
deviants1236743deviants
dewans105215143de_wan_s
dioxanes1645373dioxanes
dioxans1555313dioxan_s
disbands1237353disbands
doodad936423dooda_d_
dopants1038433d_opants
dotards937253d_otards
dromonds1244613dromonds
drownds12346153dro_wnds
elands74914773_e_lands
errands847603_errands
expands17195733_expands
fenlands1245183fenlands
headbands1644343headbands
headends13326723headends
headlands1444903headlands
hodads1147963_hoda_ds
jeopards1843683jeopards
leopards1144753leopards
leotards945303leotards
pedants10310113pe_dants
pendants1139093pendants
probands13228393probands
redans75421023re_dan_s
redounds1055963redounds
relands85214883re_lands
remands104914883re_mands
robands10219863_robands
sedans74816093se_dan_s
solands84412343_solands
teopans939203teopan_s
trolands936423trolands
videolands1551973videolands
weasands1244563weasands
weazands2143333weazands
wessands1243683wessands
wetlands1244763wetlands
woodlands1444153woodlands

Search took 8 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.423422437.4
2DLD Change Limit146162736.92021121.7
3Display Results73730.0332212.1
 (SQL Overall)178691737.37624226.0
 
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.