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

143 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
cuckoo148641(None) 
cuckoos1585121cuckoos
bucko134614022buck_o
buckos143710892buckos
cuckold1643722cuckold
cuckooed1743302cuckooed
achoo10315083_achoo
ahchoo1445713ahchoo
beckon14309383beckon
bookoo1248343bookoo
buck125129903buck__
buckaroo1644423buckaroo
bucked155121063bucked
bucker145420463bucker
buckeroo1644313buckeroo
bucket144620733bucket
buckle144815193buckle
buckoes153810393buckoes
buckra1436753buckra
bucks134824293buck_s
bunko115514513bunk_o
bunkos124210323bunkos
burgoo938933burgoo
cacao95420003cac_ao
cacaos104616183cacaos
cachou13310623cachou
cackle143416923cackle
cashoo11312253cashoo
chuck164814873chuck__
chucked19469733chucked
chuckle1836443chuckle
chucks174812933chuck_s
chucky20418003chuck_y
cicero1048503cicero
cluck134914893cluck__
clucked163810133clucked
clucks144512073cluck_s
cock126332903cock__
cockapoo1893823cockapoo
cockatoo16105783cockatoo
cocked155022563cocked
cocker144320393cocker
cockle143913573cockle
cocks135227163cock_s
cockup1635713cockup
cocky164215933cock_y
coco87330603coc__o
cocoa98517883coc_oa
cocoon10312263cocoon
cocos95624693coc_os
coo59566363__c_oo
coocoo1069693coocoo
cruck135615323cruck__
crucks144412583cruck_s
cuatro838433cuatro
cuckolds1743003cuckolds
cuckooing1843173cuckooing
cuke105824983cu_k_e
cukes115422093cu_kes
curio74221213cu_rio
curios83218333curios
cursor84110293cursor
cusk105521633cusk__
cusks114916053cusk_s
cusso74912293cu_sso
cussos84210003cussos
custom104010273custom
custos84014313custos
cyclo1237703cyc_lo
cyclos1338073cyclos
duck115929173duck__
ducked144718013ducked
ducker134317993ducker
duckie133511663duckie
ducks124823213duck_s
ducky154216113duck_y
fuck134924633fuck__
fucked164114483fucked
fucker153414423fucker
fuckoff1842393fuckoff
fucks144419253fuck_s
fuckup1733963fuckup
gecko124511113geck_o
geckos13457433geckos
guck114922533guck__
gucks123917303guck_s
huck135927633huck__
huckle153913073huckle
hucks144322173huck_s
hulloo94511733hulloo
jocko184210453jock_o
jockos19527563jockos
juco134716203juc__o
jucos144111713juc_os
luck105329823luck__
lucked135118023lucked
luckie123611413luckie
lucks115723563luck_s
lucky145515013luck_y
mucho125013443muc_ho
muck125727853muck__
mucked153816093mucked
mucker143816393mucker
muckle143413583muckle
mucks134622643muck_s
mucky165015253muck_y
mucor94011943muc_or
mucro94513723muc_ro
muskox1933953muskox
puccoon1343503puccoon
puck124927943puck__
pucka133412803puck_a
pucker143817633pucker
pucks134322103puck_s
reckon123010543reckon
rockoon1345653rockoon
ruck104728333ruck__
rucked134718763rucked
ruckle124414583ruckle
rucks114422053ruck_s
ruckus12407793ruckus
sicko115315393sick_o
sickos125112033sickos
socko115215113sock_o
succor1036623succor
suck106131733suck__
sucked134120493sucked
sucker124120663sucker
suckle124015963suckle
sucks114523073suck_s
sucky144415503suck_y
sukkot936643sukkot
tuck104626573tuck__
tucked134017493tucked
tucker124316953tucker
tucket124219483tucket
tucks114721123tuck_s
wacko145514383wack_o
wackos155210993wackos
yuck136423533yuck__
yucked164013563yucked
yucks144717193yuck_s
yucky175411693yuck_y

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 Filter1786911127160.423422437.4
2DLD Change Limit1127161435.62620034.8
3Display Results1431430.0433325.6
 (SQL Overall)1786911436.09229332.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.