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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
contos8492323(None) 
cantos84826971cantos
centos85920461centos
condos94322331condos
congos94219881congos
contes84432911contes
conto76027171conto_
bentos86218302bentos
bongos95316652bongos
bonitos939732bonitos
cansos84915382cansos
canto74931012canto_
canton85722992canton
cantons95221202cantons
cantor85621522cantor
cantors94620752cantors
cants77036942cant_s
cantus85117762cantus
centas85020702centas
cento76625172cento_
cents74730332cent_s
cestos84718092cestos
coatis85122602coatis
coats75635002coat_s
cocos95624692co_cos
cogitos1037612cogitos
cohos105921852co_hos
coitus8511892coitus
colts76633292colt_s
combos125316612combos
compos124818802compos
comtes106222812comtes
conatus9310462conatus
conchos144313962conchos
conchs134714902conchs
condo85322592condo_
condoes104319202condoes
condom114215362condom
condoms124214082condoms
condor94616972condor
condors104018572condors
cones76457422con_es
coneys115218422coneys
congas94417032congas
conges94928172conges
congo85623132congo_
congoes103617302congoes
congou94313242congou
congous103615082congous
conics103920592conics
conies84338592conies
conins84327232conins
conks115525702con_ks
conns75024232con_ns
cons66057692con__s
consol82614112consol
consols92914072consols
conte76633202cont_e
contest93523232contest
contort91422342contort
contorts101112642contorts
contour939972contour
contours1039652contours
contra83314702contra
contras93015622contras
control9310692control
controls10311392controls
contuse9311412contuse
conus76726532con_us
convoy14348542convoy
convoys15267022convoys
coos67456492co__os
coots75636842coot_s
corantos10310102corantos
cornutos1046052cornutos
cosmos10311752cosmos
costs77231142cost_s
cotes76347842co_tes
cots68054842co_t_s
cottas84615572cottas
cotton8312992cotton
cottons9312192cottons
counts84618272count_s
couths115715412couths
cunts76125122cunt_s
custos84014312custos
fonts86124752font_s
juntos134110842juntos
kotos95717702ko_tos
lentos65317402lentos
lotos54724632lo_tos
lottos64613102lottos
mondos95217332mondos
mongos94318622mongos
monos75930862mon_os
montes84226932montes
months113812932months
mottos84615242mottos
onos46229002_on_os
onto46127662_onto_
ottos54714322_ottos
pantos85222742pantos
pintos86021292pintos
pontes83627852pontes
ponton83217642ponton
pontons93315552pontons
pottos84615872pottos
puntos85915792puntos
rondos74616732rondos
rotos56027882ro_tos
santos64421832santos
tondos75115922tondos
wonton93410962wonton
wontons103310532wontons
wonts87621542wont_s

Search took 6 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 Filter178691825510.656272394.8
2DLD Change Limit825511154.98316566.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911155.68531432.0
 
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.