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

148 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
control931069(None) 
controls10311391controls
central93114472central
consol82614112con_sol
conto76027172cont_o_
contort91422342contort
contos84923232cont_os
contra83314702contr_a
contrail10410982contrail
contras93015622contras
costrel9310372costrel
decontrol1243782decontrol
antral65719413_antral
biocontrol1451743biocontrol
caltrop11267643caltrop
cantal84122033cant_al
cantdog1134573cantdog
canthal12410053canthal
canto74931013cant_o_
canton85722993cant_on
cantor85621523cant_or
cantors94620753cantors
cantos84826973cant_os
cantrap113310283cantrap
cantrip112910043cantrip
carol75128613c__arol
cental84420963cent_al
cento76625173cent_o_
centos85920463cent_os
centra84113883centr_a
centrals102712033centrals
centre84316643centr_e
centred103411683centred
centres93817123centres
centric11312403centric
centriole1145673centriole
centroid1159313centroid
centrum1168603centrum
cineol8108203cin_eol
cistron9299883cistron
citral81113893c_itral
citron83112983c_itron
coatroom1276883coatroom
coistrel1046743coistrel
coistril1046773coistril
coital84117053coit_al
coition9314313coition
conation101420883conation
conceal113313023conceal
conchal144211593conchal
concho134414263concho_
conchos144313963conchos
concord12510343concord
condo85322593con_do_
condole102914953con_dole
condom114215363con_dom
condor94616973con_dor
condors104018573condors
condos94322333con_dos
conform14310463conform
confront13411603confront
congeal104011683congeal
congo85623133con_go_
congos94219883con_gos
congou94313243con_gou
conical11316203conical
conjuror17144633conjuror
console92715983con_sole
consols92914073con_sols
consort91319903consort
construal1146803construal
construe1049053construe
consul82312303con_sul
contact1144020683contact
contain9315833contain
conte76633203cont__e
contemn1137803contemn
contend103511893contend
content94326153content
contes84432913cont_es
contest93523233contest
context163913433context
contorts101112643contorts
contour939973contour
contract122915633contract
contrails11410543contrails
contralti1147743contralti
contralto1147093contralto
contrary1347493contrary
contrast102614783contrast
contrite10318543contrite
contrive13311353contrive
controlled1345383controlled
controller1245523controller
contuse9311413contuse
convoy14348543con_voy
cool66940493co___ol
copatron1246753copatron
coral76033453co__ral
cornrow1245603cornrow
corral83616253co_rral
cortisol1045413cortisol
costal85419513cost_al
costrels1038933costrels
cotton8312993co_tton
country12388043countr_y
cuatro838433cuatro_
cuatros938273cuatros
decontrols1353123decontrols
dogtrot947443dogtrot
dottrel834463dottrel
downtrod1343353downtrod
enrol51014283_en_rol
fontal9313143font_al
foxtrot1746303foxtrot
hotrod1048803ho_trod
intro54915853_intro_
intron64215023_intron
intros64215773_intros
lintol6369473lint_ol
menthol1236733menthol
mongol94912533mon_gol
mongrel1036333mongrel
montero9310133montero_
monteros1039453monteros
monuron937463monuron
nerol51017813__nerol
noniron738373noniron
nonoral7313603nonoral
nonpros937473nonpros
nonwool1046673nonwool
nostril749303nostril
octroi837363_octroi
onto46127663_ont_o_
outroll749303_outroll
outrow9311183_outrow
patrol83213023_patrol
petrol82714063_petrol
poitrel936193poitrel
pontil8315463pont_il
ponton83217643pont_on
pontoon93010703pontoon
rostral7311333rostral
santol64515243sant_ol
sotol54917653so_t_ol
untrod769853_untrod
ventral103612173ventral
wonton93410963wont_on

Search took 7 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.406440125.6
2DLD Change Limit1340271486.09621986.1
3Display Results1481480.0602466.7
 (SQL Overall)1786911486.56227231.2
 
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.