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

178 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
duked11521846(None) 
deked115718531deked
diked115024681diked
ducked144718011ducked
duded84417131duded
duke95628101duke_
dukes105023471dukes
dunked124315281dunked
duped95118321duped
dured75025401dured
dusked124112511dusked
dyked145310951dyked
juked175714071juked
nuked104014181nuked
puked124716221puked
asked106919312asked
baked126130772baked
biked125320032biked
bucked155121062bucked
bulked134216742bulked
bunked135118372bunked
burked135220882burked
bused85624492bused
busked134917702busked
caked126128622caked
coked124730692coked
cubed105519702cubed
cued76329562cu_ed
cuke105824982cuke_
cukes115422092cukes
cured85932132cured
dared75935012dared
darked123919632darked
dated75530992dated
daubed104611782daubed
dauted84114932dauted
dawed106222812dawed
dazed165919362dazed
decked145217622decked
deed65340902d_eed
deke95228762deke_
dekes105224452dekes
deled75326542deled
deuced104112122deuced
dewed105020302dewed
diced95824682diced
dicked144920862dicked
died66137852d_ied
dike95935762dike_
diker105524552diker
dikes105831332dikes
dikey135116422dikey
dined76431992dined
dinked124818352dinked
dirked124912272dirked
disked125015762disked
dived106321372dived
docked145018332docked
doled75430912doled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
doused84821162doused
dowed104632612dowed
dozed165619352dozed
dreed75222842dreed
dried75321382dried
drouked1335542drouked
duad66521412du_ad
dubbed124113212dubbed
duce76933502duce_
duces86327472duces
ducker134317992ducker
ducted104012122ducted
dud56737592du__d
dude65629662dude_
dudes75424372dudes
due45249862du_e_
duel56729702du_el
dueled84813662dueled
dues56045502du_es
duet56446262du_et
dueted84113592dueted
duiker114110592duiker
dukedom1542772dukedom
dulled84719422dulled
dumbed124012082dumbed
dumped123814492dumped
dune56137582dune_
dunes65332172dunes
dunged95414692dunged
dunker113616462dunker
dunned85015522dunned
dunted84718502dunted
dupe76630602dupe_
duper85519002duper
dupes86425932dupes
dupped124411642dupped
dure56341812dure_
dures65635922dures
durned84113172durned
dusted83918372dusted
duvet9321872duvet
dyed96720762d_yed
dyke126418182dyke_
dykes135215572dykes
dykey16608672dykey
educed10418852educed
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
piked125623312piked
poked125425392poked
puke105025462puke_
pukes114523022pukes
puled84926522puled
quaked203910032quaked
raked105831422raked
rucked134718762rucked
rued55729792ru_ed
ruled65822522ruled
ryked13669512ryked
sucked134120492sucked
sued56537932su_ed
sulked114314702sulked
toked105626492toked
tsked105910032tsked
tubed85818042tubed
tucked134017492tucked
tuned64622312tuned
tusked114112152tusked
uke75727292_uke_
ukes86122812_ukes
used55722822_used
waked135626752waked
wauked144210572wauked
yeuked14456232yeuked
yoked134821622yoked
yucked164013562yucked
yukked13314872yukked

Search took 5 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.343520965.0
2DLD Change Limit538001783.73314412.0
3Display Results1781780.0931914.0
 (SQL Overall)1786911784.16942861.8
 
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.