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

133 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
cocottes123831(None) 
cocotte1138601cocotte_
calottes10610082calottes
cooties93725732co_oties
corotates112714282corotates
coyotes12410702coyo_tes
crocoites1347472crocoites
culottes1076292culottes
bootees94114473bo_otees
booties94124613bo_oties
boycotted1742033boycotted
boycotter1642073boycotter
boycotters1741923boycotters
boycotts1543093boycott_s
cacoethes1643633cacoethes
calotte9510563calotte_
capotes11314643capo_tes
casettes1039653casettes
cecities12312043cecities
cenotes92814543ceno_tes
chocolates1746783chocolates
chotts113610993c_hott_s
cicorees1246413cicorees
clothes124513813c_lothes
clotted104011823c_lotted
coatees93816553co_atees
coattest1038863co_attest
cocaines121314443cocaines
coccyges1542333coccyges
coccyxes2142013coccyxes
cockades1738433cockades
cockeyes1967033cockeyes
cockles153414643coc_kles
cocoas104915743coco__as
cocomats1449403cocomats
coconuts1246333coconuts
cocooned1337293cocooned
cocoons11310563coco_ons
cocos95624693coco___s
cocoyams1743453cocoyams
cocreates132611883cocreates
coesites101313093coesites
cogitates1247863cogitates
cognates11311583cognates
cohobates1646523cohobates
cohorts123411103cohort_s
cohoshes1635883cohoshes
cohosted1436143cohosted
cohostess1443463cohostess
cohosts12398813cohost_s
cojones163512103cojo_nes
collates103019143collates
colocates13312853colocates
colognes11310603colognes
colones96124433colo_nes
colonies103620013colonies
comates114123643co_mates
comities12317793comities
commutes143011893commutes
competes144117243competes
compotes144716513compotes
computes143914553computes
comtes106222813__comtes
concocted1346773concocted
concocter1247633concocter
concocters1346763concocters
concocts1138633concoct_s
concretes13411473concretes
confutes1339843confutes
connotes10311453connotes
contes84432913__contes
cooches143515833co_oches
cooees85621893co_o_ees
cookies133719273co_okies
coolies93824963co_olies
coolths1236013co_olths
coombes133810663co_ombes
coonties10513803coonties
coopted123710773co_opted
coopts105814583co_opt_s
cooter85128613co_o_ter
cooters94525733co_oters
cootie84223093co_otie_
coots75636843co_o_t_s
coplotted1444793coplotted
copouts11311083copout_s
coquettes2065983coquettes
cordites11314633cordites
corodies11313693corodies
coronates1110816923coronates
coronets103814363coronets
corotate102813933corotate_
corotated122810053corotated
corvettes1447433corvettes
cotes76347843__co_tes
cottas84615573__cottas
cotter84926673__cotter
cotters94323453__cotters
couchettes1743853couchettes
counties10316283counties
cowrites133011593cowrites
coyote11411783coyo_te_
crocoite1248053crocoite_
croutes94815653c_routes
culotte976893culotte_
curettes1039313curettes
cuvettes1335323cuvettes
footies103721543fo_oties
footles103715713fo_otles
fouettes1137883fouettes
garottes978293garottes
gavottes1274183gavottes
jockettes2254383jockettes
locates93218813loc_ates
locoes85516583loco__es
locomotes1346333locomotes
lottes65322753__lottes
mofettes1386083mofettes
mottes85523693__mottes
octets839403_oc_tets
octettes1045533octettes
oocytes1246063ooc_ytes
picotees1247113picotees
ricottas1044463ricottas
rootles73215633ro_otles
rosettes8310343rosettes
rottes64524833__rottes
scotties1039753_scotties
soothes103917113so_othes
tonettes839203tonettes
tootles72915603to_otles
tootses72910773to_otses
vicomtes1545593vicomtes

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.453394461.4
2DLD Change Limit1461621337.62619166.3
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.14221946.8
 
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.