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

66 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
spadille114519(None) 
spadilles1244991spadilles
espadrille1351672espadrille
braille939713bra_ille
cadelle1039923_cadelle
escadrille1351593escadrille
espadrilles1451553espadrilles
evadible1443973evadible
faille93414743_fa_ille
manille92613273_manille
paddle104615143_pad_dle
padle84522343_pad__le
panicle11129983_panicle
papilla11127913_papilla
papillae12137023_papillae
pastille1038943_pastille
pedicle1238973_pedicle
quadrille1944913quadrille
radiale83813523_radiale
radicle103510713_radicle
sabadilla1252693sabadilla
saddle83915493s_ad_dle
sanicle91210263s_anicle
sapodilla1252683sapodilla
sedile73517233s_edi_le
shadily1437723shadi_ly
sopapilla1352303sopapilla
spacial1138763spacial_
spacially1645653spacially
spackle15369573spa_ckle
spade84423323spad___e
spadices1336093spadices
spading113114383spadi_ng
spadix1636113spadi__x
spadixes1834113spadixes
spaetzle1942243spaetzle
spail74921553spa_i_l_
spails84817823spa_i_ls
spale74929213spa___le
spall74919303spa__ll_
spalled103113133spa__lled
spaller92713473spa__ller
spalls84217343spa__lls
spangle1038403spa_ngle
spaniel948923spaniel_
spaniels1045963spaniels
spansule1043623spansule
sparable121611983sparable
sparkle133710213spa_rkle
sparlike1437673sparlike
spatial9310323spatial_
spatially1446793spatially
spatzle1834583spa_tzle
spavie113611383spavi__e
spile75230083sp__i_le
spill74821163sp__ill_
spilled103613623sp__illed
spiller92914333sp__iller
spills84717463sp__ills
spinelle1046223spinelle
spirilla1045073spirilla
spraddle12194163sprad_dle
stabile9312063stabi_le
staddle9288093stad_dle
swaddle12276743swad_dle
taille63116923_ta_ille

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 Limit146162667.37619815.9
3Display Results66660.0302200.0
 (SQL Overall)178691667.82622833.0
 
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.