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

145 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
controls1031139(None) 
control9310691control_
centrals102712032centrals
consols92914072con_sols
contorts101112642contorts
contos84923232cont_o_s
contrails11410542contrails
contras93015622contr_as
costrels1038932costrels
decontrols1353122decontrols
biocontrols1561523biocontrols
caltrops12307863caltrops
canorous10310193canorous
cantals93919573cant_als
cantdogs1244043cantdogs
cantons95221203cant_ons
cantors94620753cant_ors
cantos84826973cant_o_s
cantraps12319113cantraps
cantrips12318933cantrips
carols85124983c__arols
centals94317053cent_als
centos85920463cent_o_s
central93114473central_
centres93817123centr_es
centriole1145673centriole
centrioles1245803centrioles
centroid1159313centroid
centroids1247043centroids
centrums1236913centrums
cineols9128853cin_eols
cistrons102710623cistrons
citrals91111673c_itrals
citrons92913223c_itrons
citrous93112993c_itrous
coatroom1276883coatroom
coatrooms1385413coatrooms
coistrels1145263coistrels
coistrils1146423coistrils
coitions10312853coitions
conations111318903conations
conceals123111013conceals
conchos144313963concho_s
concords1358593concords
condoes104319203con_does
condole102914953con_dole
condoles113015803con_doles
condoms124214083con_doms
condores113315643condores
condors104018573con_dors
condos94322333con_do_s
conforms1538873conforms
confront13411603confront
confronts1447063confronts
congeals11309853congeals
congoes103617303con_goes
congos94219883con_go_s
congous103615083con_gous
congrats11311433congrats
congress1138073congress
congruous1244343congruous
conjurors18134503conjurors
consol82614113con_sol_
console92715983con_sole
consoles103216153con_soles
consorts101512343consorts
construals1245213construals
construes11410133construes
consuls92412313con_suls
contacts123215213contacts
contains10316533contains
contemns1237403contemns
contends112810573contends
contents104018213contents
contes84432913cont__es
contests103413383contests
contexts17378653contexts
conto76027173cont_o__
contort91422343cont_ort
contour939973cont_our
contours1039653contours
contra83314703contr__a
contract122915633contract
contracts132212013contracts
contrail10410983contrail
contralti1147743contralti
contralto1147093contralto
contraltos1246763contraltos
contrary1347493contrary
contrast102614783contrast
contrasts112211043contrasts
contrite10318543contrite
contrive13311353contrive
contrives14311703contrives
controlled1345383controlled
controller1245523controller
controllers1344783controllers
contuses10413453contuses
convoys15267023con_voys
cools75632633co___ols
copatrons1346333copatrons
corals85325143co__rals
cornrows1345313cornrows
corrals93713853co_rrals
cortisols1144783cortisols
costrel9310373costrel_
cottons9312193co_ttons
countries11313613countries
cuatros938273cuatro_s
decontrol1243783decontrol_
dogtrots1044693dogtrots
dottrels963493dottrels
enrols61213383_en_rols
foxtrots1843923foxtrots
goitrous945763goitrous
hotrods1148283ho_trods
introns73515023_introns
intros64215773_intro_s
lintols7339553lint_ols
menthols1347033menthols
mongols103310823mon_gols
mongrels1135333mongrels
monstrous1187353monstrous
monteros1039453montero_s
monurons1037093monurons
nerols6914883__nerols
nonpros937473nonpro_s
nostrils848183nostrils
octrois938333_octrois
onerous7312973_onerous
outroll749303_outroll
outrolls847823_outrolls
outrows10311403_outrows
patrols93513513_patrols
petrols92913083_petrols
poitrels1035243poitrels
pontils9312213pont_ils
pontons93315553pont_ons
pontoons10279313pontoons
santols73513323sant_ols
sonorous8410413sonorous
sotols63714473so_t_ols
ventrals112910003ventrals
wondrous1246823wondrous
wontons103310533wont_ons

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.406440125.6
2DLD Change Limit1461621457.86018595.7
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.32921454.1
 
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.