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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
spraddle1219416(None) 
spraddled14203461spraddled
spraddles13194281spraddles
straddle10186221straddle
astraddle1142872astraddle
paddle104615142_p_addle
raddle84816172__raddle
saddle83915492s__addle
sprattle1054762sprattle
staddle9288092s_taddle
straddled12205022straddled
straddler11205112straddler
straddles11216402straddles
swaddle12276742s_waddle
addle74318353___addle
cradle93313163_cra_dle
daddle94214283__daddle
griddle1035503_griddle
paddled123612023_p_addled
paddler113711553_p_addler
paddles113515643_p_addles
padle84522343_p_a_dle
peddle103512823_p_eddle
piddle103514913_p_iddle
prattle9208833_prattle
puddle103914153_p_uddle
raddled103812223__raddled
raddles93615703__raddles
reddle83815913__reddle
resaddle10115223resaddle
riddle83915713__riddle
ruddle83414203__ruddle
saddled103112033s__addled
saddler93811963s__addler
saddles95415743s__addles
scrabble14196993scrabble
scramble14177253scramble
scrapple1434683scrapple
skedaddle1651303skedaddle
spackle15369573sp_ackle
spade84423323sp_a_d_e
spadille1145193sp_adille
spale74929213sp_a__le
spangle1038403sp_angle
sparable121611983sparable
sparkle133710213sp_arkle
spatzle1834583sp_atzle
spindle103210093sp_indle
spiracle1255803spira_cle
spraddling1542313spraddling
sprattled1263313sprattled
sprattles1174883sprattles
sprawl11188063spra_wl_
sprawled1434523spra_wled
sprawler1334643spra_wler
sprawls12176373spra_wls
sprawly15166043spra_wly
spreadable1544423spreadable
sprinkle1434893sprinkle
sraddha1242083s_raddha
staddles10258693s_taddles
straddlers12203823straddlers
straggle10359133straggle
strangle98411503strangle
swaddled14254963s_waddled
swaddles13296453s_waddles
treddle936433_treddle
twaddle12245713_twaddle
unriddle1043983unriddle
unsaddle1044753unsaddle
waddle114715303__waddle

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162716.50022486.5
3Display Results71710.0135461.5
 (SQL Overall)178691716.66926794.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.