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

166 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
tonsure75878(None) 
tonsured976381tonsured
tonsures869131tonsures
censure92310602censure
coinsure1046932coinsure
conjure16109072conjure
consume11510132consume
ensure63416002_ensure
insure63416602_insure
rondure837312rondure
tenure6311612ten_ure
tongue7410102tongu_e
torture738592torture
unsure62815412_unsure
assure6610773_assure
bonfire1287063bonfire
bordure1035783bordure
censured11248913censured
censurer10228133censurer
censures102211623censures
closure9278483closure
cocksure1645133cocksure
coendure1145463coendure
coenure968153coenure
coinsured1245513coinsured
coinsurer1144773coinsurer
coinsures1136723coinsures
colure8314163co_lure
concur10411103concur_
concurs11311473concurs
conduce12139233conduce
confuse1238853confuse
confute1239263confute
conjured18117903conjured
conjurer17117683conjurer
conjures17119913conjures
conquer1838623conquer
conserve1339933conserve
console92715983console
consort91319903consort
conspire1257873conspire
construe1049053construe
consul82312303consu_l
consuls92412323consuls
consult92513633consult
consumed1337923consumed
consumer1238503consumer
consumes12310413consumes
contuse9311413contuse
couture9310623couture
cynosure1343553cynosure
denture8311893denture
donsie7613643dons_ie
endure74014143_endure
ensue54013833_ensu_e
ensured83512943_ensured
ensurer73011903_ensurer
ensures73315903_ensures
enure53520223_en_ure
erasure736943erasure
fissure1036783fissure
fondue104510493fondu_e
honour94710863honour_
honoured1236313honoured
honourer1146243honourer
honours10339383honours
injure133410863_injure
insured83714253_insured
insurer73312803_insurer
insures73117263_insures
inure54119053_in_ure
jointure15134833jointure
leisure736693leisure
manure8313653man_ure
measure939033measure
moisture1046653moisture
monster93214603monster
noncore9411953noncore
nonjury1744033nonjury
nonsecure1145243nonsecure
nonsuch1244683nonsuch
nonsuit7811343nonsuit
nonuse63212253non_use
nonuser7299143nonuser
obscure1145333_obscure
onshore10310013_onshore
onside7511803_onside
ordure756813_ordure
posture9313253posture
rasure6311423_rasure
reinsure837913reinsure
rondures937713rondures
seisure738193seisure
soilure736233soilure
sonsie6614863sons_ie
sonsier7711743sonsier
stoure64814943sto__ure
sure45447413___sure
tenour62610733tenour_
tenours72610073tenours
tense55225843tens__e
tenser64919433tenser_
tensile72612733tensile
tensive10269913tensive
tensor63812673tensor_
tensors72712373tensors
tenured838363ten_ured
tenures7412013ten_ures
texture1497083texture
tincture1044673tincture
tinware1038603tinware
tissue637333tissu_e
toaster74414463toaster
toeshoe1047843toeshoe
togue64816303to_gu_e
tone46953743ton___e
tonearm937443tonearm
toneme8312103ton_eme
toner55336243ton_er_
toners64128003ton_ers
tonette7310373tonette
tonger74719693tonger_
tongers84116013tongers
tongued946323tongued
tongues879693tongues
tonier65520713tonier_
tonnage8168053tonnage
tonne54921433ton__ne
tonner64819203tonner_
tonners73816403tonners
tons46553053tons___
tonsil6311873tons_il
tonsils7310183tonsils
tonsuring1046503tonsuring
tontine72316143tontine
tonus56324303ton_u_s
tonuses73612193tonuses
topside1037743topside
toque145113093to_qu_e
tore47359323to___re
torque15237673torqu_e
torquer16205323torquer
torsade837593torsade
torse55833333tors__e
tortured935843tortured
torturer835493torturer
tortures838913tortures
tosser64215663tosser_
tossers74713503tossers
tossup875293tossu_p
tossups964023tossups
tour45530383to__ur_
toured74216153to__ured
tourer64115073to__urer
tours55325893to__urs
touse55430673to__use
tousle64514653tous_le
transude947083transude
treasure846753treasure
tressure846483tressure
tussore7317283tussore
tussur6357293tussur_
tussurs7356393tussurs
unpure82911533_unpure
venture10311173venture
zonule1577483zon_ule

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271667.34318252.3
3Display Results1661660.0762184.2
 (SQL Overall)1786911667.87222699.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.