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 “ducked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
ducked14471801(None) 
bucked155121061bucked
decked145217621decked
dicked144920861dicked
docked145018331docked
ducker134317991ducker
ducted104012121ducted
duked115218461du_ked
dunked124315281dunked
dusked124112511dusked
fucked164114481fucked
lucked135118021lucked
mucked153816091mucked
rucked134718761rucked
sucked134120491sucked
tucked134017491tucked
yucked164013561yucked
arcked136211942arcked
backed155725722backed
becked155417762becked
bucker145420462bucker
bucket144620732bucket
buckled164411882buckled
bulked134216742bulked
bunked135118372bunked
burked135220882burked
busked134917702busked
chucked19469732chucked
clucked163810132clucked
cocked155022562cocked
dacker134920752dacker
darked123919632darked
deckel134911042deckel
decker135215992decker
deked115718532d_eked
deuced104112122deuc_ed
diced95824682dic_ed
dicker134521402dicker
dickey165913522dickey
diked115024682d_iked
dinked124818352dinked
dirked124912272dirked
disked125015762disked
docker134417652docker
docket134721172docket
douched144012112douched
dubbed124113212dubbed
duce76933502duc_e_
duces86327472duc_es
duck115929172duck__
duckers143214712duckers
duckie133511662duckie
duckier143911792duckier
duckies143613812duckies
ducks124823212duck_s
duckweed1943022duckweed
ducky154216112duck_y
duded84417132du_ded
dueled84813662dueled
dueted84113592dueted
duiker114110592duiker
duke95628102du_ke_
dukes105023472du_kes
dulled84719422dulled
dumbed124012082dumbed
dumped123814492dumped
dunged95414692dunged
dunker113616462dunker
dunned85015522dunned
dunted84718502dunted
duped95118322du_ped
dupped124411642dupped
dured75025402du_red
durned84113172durned
dusted83918372dusted
dyked145310952d_yked
educed10418852educ_ed
fucker153414422fucker
funked144214112funked
gecked146911932gecked
hacked164923512hacked
hocked165521302hocked
hulked144611302hulked
husked144212222husked
jacked204817522jacked
juked175714072ju_ked
junked184311692junked
kecked125113172kecked
kicked124415942kicked
lacked135324652lacked
licked134621562licked
locked134921662locked
lurked114511972lurked
mocked154716612mocked
mucker143816392mucker
necked134715062necked
nicked135019682nicked
nocked134617382nocked
nuked104014182nu_ked
ouched124316932ouched
packed154822602packed
pecked155019102pecked
picked154421312picked
plucked16367962plucked
pocked154818982pocked
pucker143817632pucker
puked124716222pu_ked
quacked2336792quacked
quaked203910032quaked
racked134526082racked
recked134821802recked
ricked136523622ricked
rocked135022322rocked
ruched124314632ruched
ruckled144111032ruckled
sacked135525212sacked
shucked17389832shucked
sicked134524402sicked
socked134721502socked
sucker124120662sucker
suckled144212512suckled
sulked114314702sulked
tacked134723942tacked
ticked134720522ticked
trucked143910812trucked
tucker124316952tucker
tucket124219482tucket
tusked114112152tusked
wicked164317412wicked
yacked164516792yacked
yocked164114422yocked
yukked13314872yukked

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511322.39034540.2
3Display Results1321320.0334000.0
 (SQL Overall)1786911322.76664602.7
 
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.