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

76 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
resaddles1111469(None) 
resaddle10115221resaddle_
resaddled1294251resaddled
raddles93615702r__addles
reddles93315772re__ddles
rehandles1345592rehandles
resales74724902resa__les
resamples1344712resamples
saddles95415742__saddles
unsaddles1143412unsaddles
addles84216603___addles
beadles103414733be_a_dles
befuddles1642023befuddles
bemuddles1542453bemuddles
daddles104213803__daddles
heddles123311623he__ddles
meddles113213253me__ddles
paddles113515643__paddles
peddles112913703pe__ddles
pesades10310903pesa_d_es
prehandles1644183prehandles
presales10315263presa__les
raddle84816173r__addle_
raddled103812223r__addled
readded103310733re_add_ed
readdress1143823re_address
readds84111643re_add__s
readies83324713re_a_dies
reales64934123re_a__les
reddle83815913re__ddle_
reddled102912323re__ddled
regales83520793rega__les
regardless1252893regardless
rehandle1246173rehandle_
rehandled1444763rehandled
rekindles1443863rekindles
resaddling1343503resaddling
resailed93613063resa_iled
resails74616743resa_il_s
resale64025543resa__le_
resalutes947433resalutes
resample1244673resample_
resampled1454113resampled
rescales103414573res_cales
resembles1376073resembles
resettles936563resettles
resides84523283res_id_es
residues9338813res_idues
resiles74026543res__iles
resodded1136353resodd_ed
resoles73823653res__oles
respades1139853respad_es
restables111511423restables
restudies10156033restudies
restyles1139193res_tyles
retables101712673reta_bles
retackles1545363retackles
reusables1175223reusa_bles
riddles93215023r__iddles
ruddles92813873r__uddles
saddle83915493__saddle_
saddled103112033__saddled
saddler93811963__saddler
saddlers10289753__saddlers
sidesaddles145933sidesaddles
skedaddles1751203skedaddles
spraddles13194283spraddles
staddles10258693_staddles
straddles11216403straddles
swaddles13296453_swaddles
treadles939703tre_a_dles
treddles1036263tre__ddles
twaddles13315723_twaddles
unsaddle1044753unsaddle_
unsaddled1243983unsaddled
waddles124314843__waddles

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 Filter1786911486410.406440125.6
2DLD Change Limit148641767.03321134.8
3Display Results76760.0302533.3
 (SQL Overall)178691767.46923924.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.