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

171 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
cockups173522(None) 
cockup1635711cockup_
lockups1534241lockups
mockups1733341mockups
backups1736172backups
checkups2142802checkups
coccus979282coccu_s
cockers153618332cockers
cockles153414642cockles
cocks135227162cock__s
coups95522472co__ups
crackups1843122crackups
fuckups1832922fuckups
hookups1633262hookups
kickups1443502kickups
lockup1434762lockup_
lookups1332952lookups
mockup1634072mockup_
pickups1754252pickups
workups1633612workups
backup1646613backup_
bocks134526573bock__s
cackles153717203cackles
cactus104912233cactu_s
catchups1744373catchups
catsups1135333catsups
checkup2043323checkup_
chocks174815313chock__s
clockers16369813clockers
clocks144916233clock__s
closeups12102793closeups
cobnuts1135343cobnuts
cocains111313923cocains
cocas95926573coc__as
coccids11277213coccids
coccous1038993coccous
cochins141413093cochins
cock126332903cock___
cockade1638133cockade
cockades1738433cockades
cockapoo1893823cockapoo
cockapoos1993543cockapoos
cocked155022563cock_ed
cocker144320393cock_er
cockeye1867223cockeye
cockeyes1967033cockeyes
cockier154013623cockier
cockiest163013293cockiest
cockily1838493cockily
cocking163619983cocking
cockish1838503cockish
cockle143913573cock_le
cockled163710823cockled
cockney1835873cockney
cockneys1934493cockneys
cockpit1747993cockpit
cockpits1845743cockpits
cockshuts2042773cockshuts
cockshy2143223cockshy
cockspur1842603cockspur
cockspurs1942643cockspurs
cocksure1645123cocksure
cocky164215933cock__y
cocoas104915743coc_oas
coconuts1246323coconuts
cocoons11310563cocoons
cocos95624693coc__os
coitus8511893coitu_s
cokes115537193co_k_es
coleus86818273coleu_s
collops112611753collops
colours95913413colours
comous10816503comou_s
comps115526053co__mps
concours1239433concours
concurs11311453concurs
concuss1138063concuss
coniums11311863coniums
conkers133721043conkers
conks115525703conk__s
consuls92412313consuls
conus76726533co_nu_s
cookers134619463cookers
cookeys16478503cookeys
cookies133719273cookies
cookouts1445993cookouts
cooks115429143cook__s
cooktops1644063cooktops
coops96229643co__ops
copouts11311073copouts
cops86751373co___ps
corkers134118853corkers
corks116028273cork__s
cornus84816563cornu_s
corps95927043co__rps
corpus106015293corpu_s
corrupt1149093corrupt
corrupts1244973corrupts
coup86729793co__up_
coupe96023483co__upe
coupes105022523co__upes
coverups1544063coverups
coypus13389303coypu_s
crackup1743563crackup_
crockets16339543crockets
crocks145118423crock__s
crocus104813173croc_u_s
croups104312553c_roups
cuckoos1585123cuckoos
cups85430823__c_ups
cutups1036813c_utups
cyclops1635383cyclops
dockers143715003dockers
dockets144412243dockets
docks126022313dock__s
focus105815883foc_u_s
foldups1332733foldups
fuckup1733963fuckup_
hiccups1643223hiccups
hockers163915913hockers
hockeys19509273hockeys
hocks144925493hock__s
hocus104715203hoc_u_s
hokums1533923ho_kums
holdups1333593holdups
hookup1534423hookup_
jockeys23365953jockeys
jockos19527563jock_os
jocks185118083jock__s
kickup1354133kickup_
linkups1333633linkups
lockers133516923lockers
lockets134612203lockets
locknuts1443683locknuts
lockouts1445493lockouts
locks115126923lock__s
locums10478303loc_ums
locus74819993loc_u_s
lookup1233453lookup_
loups75319623lo__ups
markups1534963markups
mockers153812943mockers
mocks135023823mock__s
nocks115121013nock__s
oakums1264153_oakums
occupy1543153_occupy
occurs10136553_occurs
ockers123813903_ockers
pickup1655633pickup_
pockets154612253pockets
pocks135022963pock__s
recoups1188843recoups
rockers133916553rockers
rockets134615363rockets
rocks114626413rock__s
roups75118903ro__ups
ruckus12407793rucku_s
scaups105411933_scaups
scups95316653_sc_ups
sockets134012983sockets
socks114926083sock__s
soups75322943so__ups
stackups1643313stackups
stickups1643303stickups
tossups964013tossups
touchups1543063touchups
walkups1633013walkups
wickiups19181963wickiups
wickyups22171773wickyups
workup1534323workup_
yocks144418373yock__s

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.1561145455.1
2DLD Change Limit1340271716.76619808.9
3Display Results1711710.0433976.7
 (SQL Overall)1786911716.96525655.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.