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

140 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
diddleys1433463(None) 
diddlers11359151diddlers
diddles103915071diddle_s
diddley13388101diddley_
daddles104213802daddle_s
diddle94915212diddle__
diddled114212052diddle_d
diddler103511512diddle_r
diddlies1137592diddlies
diddly12389572diddl_y_
dindles93817242dindle_s
fiddlers13328282fiddlers
fiddles123212602fiddle_s
middlers123410192middlers
middles113415302middle_s
piddlers12359592piddlers
piddles114314272piddle_s
riddlers10269102riddlers
riddles93215022riddle_s
ridleys11145782ri_dleys
tiddlers10288652tiddlers
widdles123514342widdle_s
addles84216603_addle_s
aidless83612073ai_dless
bidders114012313bidd_ers
biddies113514493biddie_s
bindles104016453bindle_s
buddles113913073buddle_s
coddlers12359173coddlers
coddles114213593coddle_s
cuddlers12388383cuddlers
cuddles114014093cuddle_s
daddies103414943daddie_s
daddle94214283daddle__
daddled113810743daddle_d
dandlers103912053dandlers
dandles94218533dandle_s
dawdlers13375673dawdlers
dawdles12379163dawdle_s
deedless10318253deedless
diadems1135393diad_ems
dialers83614303di_alers
diallers957773diallers
dibblers13377583dibblers
dibbles124013333dibble_s
dickeys17479303di_ckeys
diddling12228743diddling
didies84621833di_die_s
didoes85716963di_doe_s
dildoes9229243dildoe_s
dimples122813213dimple_s
dindle84417223dindle__
dindled104412723dindle_d
dingeys12458403di_ngeys
dingles93818323dingle_s
dinkeys15507263di_nkeys
diodes83915783diod_e_s
dipoles101013753dipole_s
disobeys1443683disobeys
displays1446293displays
dodders105511793dodd_ers
doodlers10338843doodlers
doodles93614163doodle_s
doyleys14384923d_oyleys
dwindles13366023dwindle_s
fiddle113613383fiddle__
fiddled13329633fiddle_d
fiddler12309953fiddle_r
fiddly14328483fiddl_y_
fuddles123611933fuddle_s
giddies103713363giddie_s
girdlers10195403girdlers
girdles92210003girdle_s
griddles1145753griddle_s
heddles123311623heddle_s
hideless12278713hideless
huddlers13337633huddlers
huddles123712573huddle_s
idlers74012813_i_dlers
idles66720123_i_dle_s
kidders13399173kidd_ers
kiddies133412283kiddie_s
kiddoes13387063kiddoe_s
kidneys1533423ki_dneys
kindlers13318483kindlers
kindles123614843kindle_s
kindless13289243kindless
lidless8309273li_dless
meddlers12318203meddlers
meddles113213253meddle_s
medleys13115333_medleys
middays14335663midd_ays
middens11379383midd_ens
middies113116153middie_s
middle103414983middle__
middled123311903middle_d
middler112712273middle_r
midlegs1156323mi_dlegs
mindless11319443mindless
muddlers12428813muddlers
muddles112914353muddle_s
noddles92911293noddle_s
paddlers12329153paddlers
paddles113515643paddle_s
peddlers12298533peddlers
peddles112913703peddle_s
piddle103514913piddle__
piddled123311253piddle_d
piddler112911523piddle_r
piddly13319143piddl_y_
puddlers12298683puddlers
puddles113613823puddle_s
raddles93615703raddle_s
reddles93315773reddle_s
ridders93612493ridd_ers
riddle83915713riddle__
riddled103012043riddle_d
riddler93411263riddle_r
ridley10169543ri_dley_
rindless92510193rindless
ruddles92813873ruddle_s
saddlers10289753saddlers
saddles95415743saddle_s
sidlers83414233si_dlers
sidles74721153si_dle_s
tiddler93110003tiddle_r
tiddly11308783tiddl_y_
tideless9269083tideless
toddlers10346963toddlers
toddles93211533toddle_s
twiddlers14313693twiddlers
twiddles13265613twiddle_s
waddlers13298333waddlers
waddles124314843waddle_s
widders123512273widd_ers
widdies123514033widdie_s
widdle113814843widdle__
widdled133511233widdle_d
windles113518493windle_s
windless123310863windless

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621407.17320376.7
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.63923391.9
 
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.