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

191 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
puked12471622(None) 
duked115218461duked
juked175714071juked
nuked104014181nuked
piked125623311piked
poked125425391poked
puke105025461puke_
pukes114523021pukes
puled84926521puled
asked106919312asked
baked126130772baked
biked125320032biked
bucked155121062bucked
bulked134216742bulked
bunked135118372bunked
burked135220882burked
bused85624492bused
busked134917702busked
caked126128622caked
coked124730692coked
cubed105519702cubed
cued76329562cu_ed
cuke105824982cuke_
cukes115422092cukes
cured85932132cured
deked115718532deked
diked115024682diked
ducked144718012ducked
duded84417132duded
duke95628102duke_
dukes105023472dukes
dunked124315282dunked
duped95118322duped
dured75025402dured
dusked124112512dusked
dyked145310952dyked
eked96718022_eked
faked135225482faked
fluked145112092fluked
fucked164114482fucked
fumed116118822fumed
funked144214112funked
fused94820442fused
fuzed185415252fuzed
guyed1049892guyed
hiked135919202hiked
hoked135326992hoked
hued86925852hu_ed
hulked144611302hulked
husked144212222husked
inked104218522inked
irked104510922irked
jauked18489012jauked
joked175217912joked
jouked18568152jouked
juke154721662juke_
jukes165319102jukes
junked184311692junked
laked105731122laked
liked104523812liked
lubed85319892lubed
lucked135118022lucked
luged74019092luged
lured65427492lured
lurked114511972lurked
luted64826142luted
miked125020452miked
mucked153816092mucked
muled85824432muled
mured85726702mured
mused85524582mused
muted85023382muted
naked105320852naked
nuke85920752nuke_
nukes95418122nukes
outed65429062outed
paced106931682paced
packed154822602packed
paged95926782paged
paiked135113432paiked
paled85538722paled
paned85437182paned
pared86946762pared
parked134425142parked
pated85237842pated
paused95114962paused
paved115525262paved
pawed115725612pawed
payed115925932payed
peaked136117402peaked
pecked155019102pecked
ped66751522p__ed
peed76239182p_eed
peeked134314582peeked
peke105926202peke_
pekes114623562pekes
perked134617692perked
peruked14367892peruked
picked154421312picked
pied75035362p_ied
pike106335212pike_
piker115622842piker
pikes115031032pikes
piled85232992piled
pined85935322pined
pinked134819882pinked
piped105123162piped
pled75231432p_led
plied85118592plied
plucked16367962plucked
plumed114412882plumed
plunked14429592plunked
pocked154818982pocked
poke105335362poke_
poker115122882poker
pokes116133012pokes
pokey145318972pokey
poled84934842poled
pooed85226242pooed
pored85234512pored
porked134717622porked
posed85828412posed
poufed12449712poufed
poured95116742poured
pouted94021392pouted
poxed154817862poxed
preed85128122preed
pried84426862pried
pruned93413112pruned
pubes94423402pubes
puce85127882puce_
puces94924632puces
pucker143817632pucker
pud65836652pu__d
puffed153510602puffed
pugged114314532pugged
pukka10457132pukka
pule65040952pule_
puler74826622puler
pules74538812pules
pulled94322192pulled
pulped114612532pulped
pulsed94013722pulsed
pumped133915562pumped
punker123718822punker
punkey154011172punkey
punned93416192punned
punted94618712punted
pupped105013272pupped
pure65543332pure_
puree74632842puree
pureed95017812pureed
purer75127902purer
purged104918262purged
purled94520752purled
purred94218072purred
pursed95220882pursed
puses75532202puses
pushed125017462pushed
putted94220252putted
putzed18409112putzed
quaked203910032quaked
raked105831422raked
rucked134718762rucked
rued55729792ru_ed
ruled65822522ruled
ryked13669512ryked
spiked134915552spiked
spoked134413892spoked
spued84918472spu_ed
spumed114711542spumed
spunked14307782spunked
sucked134120492sucked
sued56537932su_ed
sulked114314702sulked
toked105626492toked
tsked105910032tsked
tubed85818042tubed
tucked134017492tucked
tuned64622312tuned
tusked114112152tusked
uke75727292_uke_
ukes86122812_ukes
upped103715162upped
used55722822_used
waked135626752waked
wauked144210572wauked
yeuked14456232yeuked
yoked134821622yoked
yucked164013562yucked
yukked13314872yukked

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001911.37339184.3
3Display Results1911910.0464152.2
 (SQL Overall)1786911911.715104193.0
 
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.