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

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

251 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
diddley1338810(None) 
diddle94915211diddle_
diddled114212051diddled
diddler103511511diddler
diddles103915071diddles
diddleys14334631diddleys
diddly12389571diddl_y
daddle94214282daddle_
daddled113810742daddled
daddles104213802daddles
diddlers11359152diddlers
diddlies1137592diddlies
dindle84417222dindle_
dindled104412722dindled
dindles93817242dindles
fiddle113613382fiddle_
fiddled13329632fiddled
fiddler12309952fiddler
fiddles123212602fiddles
fiddly14328482fiddl_y
middle103414982middle_
middled123311902middled
middler112712272middler
middles113415302middles
piddle103514912piddle_
piddled123311252piddled
piddler112911522piddler
piddles114314272piddles
piddly13319142piddl_y
riddle83915712riddle_
riddled103012042riddled
riddler93411262riddler
riddles93215022riddles
ridley10169542ri_dley
tiddler93110002tiddler
tiddly11308782tiddl_y
widdle113814842widdle_
widdled133511232widdled
widdles123514342widdles
addle74318353_addle_
addled94112523_addled
addles84216603_addles
bidden104010793bidd_en
bidder104114863bidd_er
biddies113514493biddies
biddy124612693bidd__y
bindle94516263bindle_
bindles104016453bindles
buddle104313083buddle_
buddles113913073buddles
coddle104713853coddle_
coddled123410573coddled
coddler113710833coddler
coddles114213593coddles
cuddle104414533cuddle_
cuddled124110763cuddled
cuddler113810743cuddler
cuddles114014093cuddles
cuddly13388413cuddl_y
daddies103414943daddies
daddy116212563dadd__y
dandle84218093dandle_
dandled103313543dandled
dandler94414273dandler
dandles94218533dandles
dawdle11399503dawdle_
dawdled13376723dawdled
dawdler12356793dawdler
dawdles12379163dawdles
deadly113811473deadl_y
diablery1443233diablery
diadem1037583diad_em
dialed84716453di_aled
dialer74315433di_aler
dialled9510133dialled
diallel845683diallel
dialler848813dialler
dibble114013843dibble_
dibbled133510843dibbled
dibbler124510283dibbler
dibbles124013333dibbles
dicey114819333di__cey
dickey165913523di_ckey
diddling12228743diddling
didie74120563di_die_
didies84621833di_dies
didoes85716963di_does
didy99121503di_d__y
dikey135116423di__key
dildoe8198673dildoe_
dildoes9229243dildoes
dilled84122223di_lled
dilly94923783di__lly
dimly114913483di_ml_y
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
dimply14339743dimpl_y
dingey114914053di_ngey
dingle84317073dingle_
dingles93818323dingles
dinkey144812763di_nkey
dinkly144311083dinkl_y
diode74716113diod_e_
diodes83915783diod_es
diplex16408053di_plex
dipole91112853dipole_
dipoles101013753dipoles
direly10311563direl_y
dirled84514903di_rled
disobey1346243disobey
display1336663display
dodder94712913dodd_er
doddery13516853doddery
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doyley13487283d_oyley
duddie9348863duddie_
duddy114911033dudd__y
dwindle12415883dwindle_
dwindled14385023dwindled
dwindles13366023dwindles
fiddlers13328283fiddlers
fuddle113312103fuddle_
fuddled13309393fuddled
fuddles123611933fuddles
giddied11257713giddied
giddier10308723giddier
giddies103713363giddies
giddily1335073giddily
giddy115810203gidd__y
girdle82110463girdle_
girdled10217453girdled
girdler9227313girdler
girdles92210003girdles
griddle1035503griddle_
griddled1244203griddled
griddles1145753griddles
heddle114211163heddle_
heddles123311623heddles
hidden11429743hidd_en
huddle113712993huddle_
huddled13349783huddled
huddler12379423huddler
huddles123712573huddles
idle55423763_i_dle_
idled74915213_i_dled
idler65015663_i_dler
idles66720123_i_dles
idly85617323_i_dl_y
kidded13299383kidd_ed
kidder123811093kidd_er
kiddie12359393kiddie_
kiddies133412283kiddies
kiddoes13387063kiddoes
kiddy144910273kidd__y
kidney1434753ki_dney
kindle114414233kindle_
kindled133410543kindled
kindler12309983kindler
kindles123614843kindles
kindly14358843kindl_y
lidded93410243lidd_ed
meddle103312763meddle_
meddled123210033meddled
meddler11319953meddler
meddles113213253meddles
medley1298333_medley
midday13327503midd_ay
midden104112853midd_en
middies113116153middies
middlers123410193middlers
middy124812593midd__y
midleg1038553mi_dleg
mildly12318243mildl_y
muddle103414633muddle_
muddled124111593muddled
muddler113411623muddler
muddles112914353muddles
muddly13418603muddl_y
noddle83211363noddle_
noddled10358563noddled
noddles92911293noddles
oddly1037163_oddl_y
paddle104615143paddle_
paddled123612023paddled
paddler113711553paddler
paddles113515643paddles
peddle103512823peddle_
peddled123410533peddled
peddler113210493peddler
peddlery15224003peddlery
peddles112913703peddles
piddlers12359593piddlers
puddle103914153puddle_
puddled123011193puddled
puddler112910753puddler
puddles113613823puddles
puddly13438133puddl_y
raddle84816173raddle_
raddled103812223raddled
raddles93615703raddles
reddle83815913reddle_
reddled102912323reddled
reddles93315773reddles
ridded93615123ridd_ed
ridden83511723ridd_en
ridder84015143ridd_er
riddlers10269103riddlers
ridleys11145783ri_dleys
riley84420583ri__ley
ruddle83414203ruddle_
ruddled103010873ruddled
ruddles92813873ruddles
saddle83915493saddle_
saddled103112033saddled
saddler93811963saddler
saddlery13274913saddlery
saddles95415743saddles
sidle65124033si_dle_
sidled84215173si_dled
sidler74716963si_dler
sidles74721153si_dles
tidally1137933tidally
tiddlers10288653tiddlers
tidily102811393tidil_y
toddle85811033toddle_
toddled10328823toddled
toddler9379043toddler
toddles93211533toddles
twiddle12305483twiddle_
twiddled14284633twiddled
twiddler13244873twiddler
twiddles13265613twiddles
twiddly15233773twiddl_y
waddle114715303waddle_
waddled133611643waddled
waddler124010793waddler
waddles124314843waddles
waddly14478723waddl_y
widder112913973widd_er
widdie113410733widdie_
widdies123514033widdies
widdy136112183widd__y
widely133311033widel_y
wildly13328123wildl_y
windle104617953windle_
windled123713483windled
windles113518493windles

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272516.45320769.7
3Display Results2512510.0932698.9
 (SQL Overall)1786912516.70226662.3
 
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.