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

141 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
fuckup173396(None) 
fuckups1832921fuckups
backup1646612backup
cockup1635712cockup
faceup1334892faceup
fuck134924632fuck__
fucked164114482fucked
fucker153414422fucker
fucks144419252fuck_s
fucous11399862fucous
fucus105515892fuc_us
kickup1354132kickup
lockup1434762lockup
mockup1634072mockup
pickup1655632pickup
ruckus12407792ruckus
backups1736173backups
buck125129903buck__
bucked155121063bucked
bucker145420463bucker
bucket144620733bucket
buckle144815193buckle
bucko134614023buck_o
buckos143710893buckos
buckra1436753buckra
bucks134824293buck_s
bunkum1435983bunkum
bupkus14385683bupkus
checkup2043323checkup
cockups1735223cockups
coup86729793__coup
crackup1743563crackup
cuckoo1486413cuckoo
cup76738243__c_up
cutup9410093cu_tup
duck115929173duck__
ducked144718013ducked
ducker134317993ducker
duckie133511663duckie
ducks124823213duck_s
ducky154216113duck_y
dustup935363dustup
feck134923433feck__
feckly18335963feckly
fecks145417853feck_s
fichu134810663fichu_
fichus14388113fichus
fickle153912973fickle
fickly18318533fickly
ficus105015493fic_us
focus105815883foc_us
foldup1233813foldup
fuci95720313fuc__i
fuckers163611593fuckers
fucking173212283fucking
fuckoff1842393fuckoff
fucoid1237893fucoid
fucose11167683fucose
fugu85419863fu_gu_
fugue94313373fu_gue
fugus95914013fu_gus
fulcrum1443483fulcrum
fundus10429173fundus
fungus10418183fungus
funk115825623funk__
funked144214113funked
funker133915763funker
funkia1336343funkia
funks125318913funk_s
funky154315133funk_y
furfur1235553furfur
fuscous1256673fuscous
guck114922533guck__
gucks123917303guck_s
hiccup1554393hiccup
hookup1534423hookup
huck135927633huck__
huckle153913073huckle
hucks144322173huck_s
juku154414853ju_ku_
jukus16398673ju_kus
kickups1443503kickups
linkup1245123linkup
lockups1534243lockups
lookup1233453lookup
luck105329823luck__
lucked135118023lucked
luckie123611413luckie
lucks115723563luck_s
lucky145515013luck_y
markup1436903markup
mockups1733343mockups
muck125727853muck__
mucked153816093mucked
mucker143816393mucker
muckle143413583muckle
mucks134622643muck_s
mucky165015253muck_y
mucluc1245053mucluc
mucous104411653mucous
mucus94015743muc_us
pickups1754253pickups
puck124927943puck__
pucka133412803puck_a
pucker143817633pucker
pucks134322103puck_s
pullup1045893pullup
pushup1335273pushup
recoup10810373recoup
ruck104728333ruck__
rucked134718763rucked
ruckle124414583ruckle
rucks114422053ruck_s
scaup95515993_scaup
scup84822383_sc_up
stackup1533743stackup
stickup1533853stickup
suck106131733suck__
sucked134120493sucked
sucker124120663sucker
suckle124015963suckle
sucks114523073suck_s
sucky144415503suck_y
sunup7313053su_nup
touchup1443833touchup
tuchun1145443tuchun
tuck104626573tuck__
tucked134017493tucked
tucker124316953tucker
tucket124219483tucket
tucks114721123tuck_s
tuneup835203tuneup
turnup835093turnup
walkup1534193walkup
wickiup18172673wickiup
wickyup21171883wickyup
workup1534323workup
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.373479064.3
2DLD Change Limit1127161415.58020200.0
3Display Results1411410.0463065.2
 (SQL Overall)1786911415.99929786.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.