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

130 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
nuked10401418(None) 
duked115218461duked
juked175714071juked
naked105320851naked
nuke85920751nuke_
nukes95418121nukes
puked124716221puked
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
enured73315332enured
faked135225482faked
fluked145112092fluked
fucked164114482fucked
fumed116118822fumed
funked144214112funked
fused94820442fused
fuzed185415252fuzed
guyed1049892guyed
hiked135919202hiked
hoked135326992hoked
hued86925852hu_ed
hulked144611302hulked
husked144212222husked
inked104218522inked
inured73114812inured
irked104510922irked
jauked18489012jauked
joked175217912joked
jouked18568152jouked
juke154721662juke_
jukes165319102jukes
junked184311692junked
laked105731122laked
liked104523812liked
lubed85319892lubed
lucked135118022lucked
luged74019092luged
lured65427492lured
lurked114511972lurked
luted64826142luted
miked125020452miked
mucked153816092mucked
muled85824432muled
mured85726702mured
mused85524582mused
muted85023382muted
naled65525052naled
named85223062named
narked114116742narked
necked134715062necked
need54934152n_eed
nicked135019682nicked
nided75920872nided
nixed135714222nixed
nocked134617382nocked
nosed65524552nosed
noted65123842noted
nude56626272nude_
nuder66416832nuder
nudes64723292nudes
nudged95511842nudged
nulled74318272nulled
numbed114111442numbed
numen74216792numen
nurd56224342nu_rd
nurled74016232nurled
nursed74514662nursed
nutted74316972nutted
outed65429062outed
piked125623312piked
poked125425392poked
puke105025462puke_
pukes114523022pukes
puled84926522puled
quaked203910032quaked
raked105831422raked
rucked134718762rucked
rued55729792ru_ed
ruled65822522ruled
ryked13669512ryked
snaked115017592snaked
sucked134120492sucked
sued56537932su_ed
sulked114314702sulked
toked105626492toked
tsked105910032tsked
tubed85818042tubed
tucked134017492tucked
tuned64622312tuned
tusked114112152tusked
uke75727292_uke_
ukes86122812_ukes
unfed94614222unfed
unkend11309222unkend
unled64021072unled
unused72012882unused
unwed94114872unwed
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.310576422.6
2DLD Change Limit538001301.40638264.6
3Display Results1301300.0462826.1
 (SQL Overall)1786911301.762101413.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.