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

179 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
contours103965(None) 
concours1239471concours
contour939971contour_
candours11408642candours
cantors94620752canto_rs
centaurs1035732centaurs
colours95913442co_lours
concourse1345802concourse
concurs11311472con_curs
condors104018572condo_rs
congous103615082congou_s
contort91422342conto_rt
contorts101112642contorts
contos84923232conto__s
contoured1237302contoured
ecotours1044462eco_tours
honours10339372hon_ours
recontours1243462recontours
santours837182santours
candors104216763cando_rs
candour104210243candour_
canoers94318373can_oers
canters94827733cant_ers
canthus1248713canthu_s
cantons95221203canto_ns
cantor85621523canto_r_
cantos84826973canto__s
cantus85117763cant_u_s
captors113914983capto_rs
castors94919443casto_rs
censors93611843censo_rs
centaur935783centaur_
centaury1343953centaury
centers94420603cent_ers
centners1057243centners
centones10313663centones
centos85920463cento__s
centrums1236913centrums
centums11398783cent_ums
century1237193cent_ury
chantors133710263chanto_rs
clamours1255993clamours
clangours12263123clangours
clours85215093c__lours
coactors1239473coacto_rs
coaters93525793coat_ers
coccous1039003coccou_s
cointers103616413coint_ers
coitus8511893coit_u_s
colors86622373co_lo_rs
colour85915093co_lour_
colters93522443colt_ers
comous10816503co_mou_s
conatus9310463conatu_s
concocts1138633concocts
concord12510343conco_rd
concords1358593concords
concourses1445353concourses
concur10411103con_cur_
concuss1138063con_cuss
condoes104319203condo_es
condolers122710573condolers
condoles113015803condoles
condoms124214083condo_ms
condoners122811513condoners
condones112817393condones
condor94616973condo_r_
condores113315643condores
condos94322333condo__s
confers124120093con_fers
conform14310463confo_rm
conforms1538873conforms
confound1445903confound
confounds1544323confounds
congers104223233con_gers
congius103210073congiu_s
congoes103617303congo_es
congos94219883congo__s
congou94313243congou__
conifers133611703conifers
conioses10313313conioses
coniosis1048133coniosis
coniums11311863con_iums
conjoins1738133conjoins
conjure16109073con_jure
conjures17119913con_jures
conkers133721043con_kers
conners94023113con_ners
connotes10311453connotes
conoids10813883con_oids
conquers1938223conquers
consolers112510923consolers
consoles103216153consoles
consols92914073conso_ls
consort91319903conso_rt
consorts101512343consorts
construers1245873construers
construes11410133construes
consuls92412313con_suls
contacts123215213contacts
contains10316533contains
contemns1237403contemns
contends112810573contends
contents104018213contents
contes84432913cont__es
contests103413383contests
contexts17378653contexts
continuers1247943continuers
continues11310993continues
continuos1147003continuos
conto76027173conto___
contouring1347013contouring
contra83314703cont__ra
contrary1347493contrary
contras93015623cont_ras
controls10311393controls
contuse9311413cont_use
contuses10413453contuses
conus76726533con__u_s
convokers18246103convokers
convokes17247703convokes
convoys15267023convo_ys
cooers84324563co__oers
cookouts1446003cookouts
cooters94525723coot_ers
copious11311963copiou_s
copouts11311083co_pouts
copters113621283copt_ers
cormous11312353cormou_s
corneous10310033corneou_s
costars94218013cost_ars
costers94128333cost_ers
cothurn1245053co_thurn
cothurns1344523co_thurns
cottars94412243co_ttars
cotters94323443co_tters
cottiers10399153cottiers
cottons9312193cotto_ns
couloirs1045993couloirs
counters103320193count_ers
couters93827303cout_ers
couture9310623cout_ure
coutures10311993cout_ures
covetous1347093covetou_s
coypous14248813coypou_s
critturs10374593critturs
cutouts938033c_utouts
detours858043_detours
doctors1039993docto_rs
dolours8438823do_lours
donators9310403donato_rs
donors75115793don_o_rs
downpours1542533downpours
ecotour944363eco_tour_
faitours1134263faitours
foetors1039763foeto_rs
honors94816793hon_o_rs
honour94710863hon_our_
inpours936423_inpours
mentors9314993mento_rs
monitors10310823monito_rs
motors84616603mo_to_rs
odours7418253_o_dours
outpours1036683_outpours
pandours11317993pandours
pantoums1236713pantoums
pontons93315553ponto_ns
pontoons10279313pontoons
raconteurs1241843raconteurs
rancours1076713rancours
recontour1143713recontour_
rotors64917953ro_to_rs
santoors837633santoors
santour737373santour_
santurs7310763sant_urs
stours65015633__stours
tenours72610073ten_ours
tours55325893___tours
wontons103310533wonto_ns

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.436409841.7
2DLD Change Limit1461621798.01618233.8
3Display Results1791790.0802237.5
 (SQL Overall)1786911798.53220943.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.