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

120 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
tonsured97638(None) 
tonsure758781tonsure_
tonsures869131tonsures
censured11248912censured
coinsured1245512coinsured
conjured18117902conjured
consumed1337922consumed
ensured83512942_ensured
honoured1236312honoured
insured83714252_insured
tenured838362ten_ured
tongued946322tongu_ed
tortured935842tortured
toured74216152to__ured
assured858373_assured
censored11197953censored
censure92310603censure_
censurer10228133censurer
censures102211623censures
censused11184973censused
closured11266353closured
coendured1344093coendured
coinsure1046933coinsure_
coinsurer1144773coinsurer
coinsures1136723coinsures
coloured1148313coloured
concurred1445673concurred
conduced14136963conduced
confused1437033confused
confuted1437683confuted
conjure16109073conjure_
conjurer17117683conjurer
conjures17119913conjures
conquered2145463conquered
conserved1538853conserved
consoled112911453consoled
consorted1239773consorted
conspired1445663conspired
construed1247313construed
consulted1277923consulted
consume11510133consume_
consumer1238503consumer
consumes12310413consumes
contoured1237303contoured
contused1138443contused
donnered10307753donnered
endured93611213_endured
ensued73610483_ensu_ed
ensure63416003_ensure_
ensurer73011903_ensurer
ensures73315903_ensures
enured73315333_en_ured
fissured1235183fissured
fondued12466363fondu_ed
honored11310123hon_ored
honourer1146243honourer
injured15339063_injured
insure63416603_insure_
insureds9277613_insureds
insurer73312803_insurer
insures73117263_insures
inured73114813_in_ured
jointured17133483jointured
leisured934763leisured
loured74617403lo__ured
manured1039473man_ured
measured1136463measured
mongered1238953mongered
noninsured1153273noninsured
nonsacred1244673nonsacred
nonsked1236233nons_ked
nonsuited1046573nonsuited
obscured1343893_obscured
pondered126411293pondered
postured1139493postured
poured95116743po__ured
reinsured1036983reinsured
rondure837313rondure_
rondures937713rondures
soured74921863so__ured
sponsored1243223sponsored
taboured1156273taboured
tendered102510603tendered
tensed74817833tens__ed
tentered96412103tentered
tenure6311613ten_ure_
tenures7412013ten_ures
textured1695483textured
tinctured1243513tinctured
tinkered1387683tinkered
tinseled935763tinseled
tissued835583tissu_ed
toasted84011923toas_ted
tochered1437913tochered
toned65435343ton___ed
tonged86518903ton__ged
tongue7410093tongu_e_
tongues879693tongu_es
tonsuring1046503tonsuring
tonuses73612193ton_uses
torqued17224893torqu_ed
torture738593torture_
torturer835493torturer
tortures838913tortures
tossed74215223to_s_sed
tottered9208703tottered
tourer64115073to__urer
toused74122013to__used
tousled84710363tous_led
touted74419743to__uted
towered112911403to_wered
transuded1145473transuded
treasured1044983treasured
uncured10513233_uncured
unensured1044943unensured
uninsured1044873uninsured
unsoured9310063_unsoured
unsure62815413_unsure_
ventured1238273ventured
wondered13239943wondered

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.406440125.6
2DLD Change Limit1461621206.56322270.6
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.01525472.7
 
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.