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

117 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
twiddlers1431369(None) 
tiddlers10288651t_iddlers
twaddlers14343611twaddlers
twiddler13244871twiddler_
twiddles13265611twiddle_s
diddlers11359152_diddlers
fiddlers13328282_fiddlers
middlers123410192_middlers
piddlers12359592_piddlers
riddlers10269102_riddlers
swindlers13306032swindlers
tiddler93110002t_iddler_
toddlers10346962t_oddlers
twaddler13314642twaddler_
twaddles13315722twaddle_s
twiddle12305482twiddle__
twiddled14284632twiddle_d
twiddlier1441862twiddlier_
twinklers1633062twinklers
twirlers11274302twi_rlers
waddlers13298332_waddlers
widders123512272_widd_ers
widdles123514342_widdle_s
bidders114012313_bidd_ers
bridlers11359183bri_dlers
coddlers12359173_coddlers
cuddlers12388383_cuddlers
diddler103511513_diddler_
diddles103915073_diddle_s
diddleys14334633_diddleys
dwindles13366023dwindle_s
fiddler12309953_fiddler_
fiddles123212603_fiddle_s
girdlers10195403_girdlers
gridders11286293gridd_ers
griddles1145753griddle_s
huddlers13337633_huddlers
idlers74012813__i_dlers
kidders13399173_kidd_ers
kindlers13318483_kindlers
meddlers12318203_meddlers
middler112712273_middler_
middles113415303_middle_s
muddlers12428813_muddlers
paddlers12329153_paddlers
peddlers12298533_peddlers
piddler112911523_piddler_
piddles114314273_piddle_s
puddlers12298683_puddlers
ridders93612493_ridd_ers
riddler93411263_riddler_
riddles93215023_riddle_s
saddlers10289753_saddlers
sidlers83414233_si_dlers
skidders1454823skidd_ers
spindlers12286453spindlers
straddlers12203823straddlers
swaddles13296453swaddle_s
swiddens1342713swidd_ens
swillers11299113swi_llers
swindler12257723swindler_
swindles12319503swindle_s
swizzlers2052193swizzlers
tailers73720183tai__lers
tedders94010233t_edd_ers
ticklers14339303t_icklers
tideless9269083t_ideless
tidiers8389773t_i_diers
tilers63523503t_i__lers
tillers73418743t_i_llers
tinders84219173t_ind_ers
tinglers93710593t_inglers
tinklers12298183t_inklers
tipplers12336353t_ipplers
toddler9379043t_oddler_
toddles93211533t_oddle_s
toilers74116263toi__lers
treadlers1045893treadlers
treddles1036263treddle_s
triflers113110213tri_flers
trillers83613493tri_llers
trindles93211683trindle_s
trundlers10215003trundlers
twaddle12245713twaddle__
twaddled14254623twaddle_d
twanglers1363433twanglers
tweedles1234113tweedle_s
twiddliest1542023twiddliest
twiddling1543083twiddling
twiddly15233773twiddl__y
twiers95410163twi___ers
twigless1293663twi_gless
twiners10459633twi__ners
twinkler1564073twinkler_
twinkles1535073twinkle_s
twirler10285203twi_rler_
twisters11268173twi_sters
twitchers17134533twitchers
twitters11296773twi_tters
unriddlers1241823unriddlers
wadders123812443_wadd_ers
waddler124010793_waddler_
waddles124314843_waddle_s
wedders123610723_wedd_ers
widder112913973_widd_er_
widdies123514033_widdie_s
widdle113814843_widdle__
widdled133511233_widdle_d
wideners12257993_wideners
widowers1535113_widowers
wielders12196613_wielders
wigglers13257213_wigglers
wilders113513503_wild_ers
willers103517913_wi_llers
winders113721263_wind_ers
windles113518493_windle_s
windless123310863_windless

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit1486411177.61019532.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.10922036.1
 
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.