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

151 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
duded8441713(None) 
dude65629661dude_
dudes75424371dudes
duked115218461duked
duped95118321duped
dured75025401dured
added84918432added
aided75828932aided
audad71511392audad
bided95424962bided
boded95124962boded
budded113912332budded
budged114517232budged
bused85624492bused
ceded96118552ceded
coded95433182coded
cubed105519702cubed
cued76329562cu_ed
curded104217162curded
cured85932132cured
dadoed9449902dadoed
dared75935012dared
dated75530992dated
daubed104611782daubed
dauted84114932dauted
dawed106222812dawed
dazed165919362dazed
deed65340902d_eed
deeded94615542deeded
deked115718532deked
deled75326542deled
deluded10158762deluded
denuded10167662denuded
deuced104112122deuced
dewed105020302dewed
diced95824682diced
died66137852d_ied
diked115024682diked
dined76431992dined
dived106321372dived
dodged107514682dodged
doled75430912doled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
doused84821162doused
dowed104632612dowed
dozed165619352dozed
dreed75222842dreed
dried75321382dried
drudged11277612drudged
duad66521412du_ad
dubbed124113212dubbed
duce76933502duce_
duces86327472duces
ducked144718012ducked
ducted104012122ducted
dud56737592du__d
duddy114911032duddy
dudeen857172dudeen
duds65530142dud_s
due45249862du_e_
duel56729702du_el
dueled84813662dueled
dues56045502du_es
duet56446262du_et
dueted84113592dueted
duke95628102duke_
dukes105023472dukes
dulled84719422dulled
dumbed124012082dumbed
dumped123814492dumped
dune56137582dune_
dunes65332172dunes
dunged95414692dunged
dunked124315282dunked
dunned85015522dunned
dunted84718502dunted
dupe76630602dupe_
duper85519002duper
dupes86425932dupes
dupped124411642dupped
dure56341812dure_
dures65635922dures
durned84113172durned
dusked124112512dusked
dusted83918372dusted
duvet9321872duvet
dyed96720762d_yed
dyked145310952dyked
educed10418852educed
eluded84612772eluded
ended74421262ended
exuded15317682exuded
faded105025242faded
feuded114010002feuded
fudged125212812fudged
fumed116118822fumed
funded114413892funded
fused94820442fused
fuzed185415252fuzed
gude65423332gude_
gudes74520812gudes
guided94014112guided
guyed1049892guyed
haded105227622haded
hided105222442hided
hued86925852hu_ed
jaded144417032jaded
judged165911252judged
juked175714072juked
laded74232612laded
lauded83812152lauded
lubed85319892lubed
lude55331642lude_
ludes65728852ludes
luged74019092luged
lured65427492lured
luted64826142luted
mudded114511382mudded
muled85824432muled
mured85726702mured
mused85524582mused
muted85023382muted
nided75920872nided
nude56626272nude_
nuder66416832nuder
nudes64723292nudes
nudged95511832nudged
nuked104014182nuked
outed65429062outed
puked124716222puked
puled84926522puled
reded74829112reded
rudd65917472rud_d
rude55632782rude_
ruder65320542ruder
rued55729792ru_ed
ruled65822522ruled
sided74825952sided
sudd64719772sud_d
sudsed83911372sudsed
sued56537932su_ed
sueded84014632sueded
tided76322512tided
tubed85818042tubed
tuned64622312tuned
udder76314282udder
used55722822_used
waded106024752waded

Search took 4 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.0961861364.6
2DLD Change Limit538001512.96618138.9
3Display Results1511510.0931623.7
 (SQL Overall)1786911513.15556637.4
 
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.