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

115 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
pastille103894(None) 
bastille1048001bastille
pastilles1148701pastilles
apostille1144242apostille
astilbe945652_astilbe
bastile9313912basti_le
bastilles1147362bastilles
pantile93918482panti_le
partible1238062partible
particle1239532particle
passible1237692passible
pastiche1546932pastiche
pastie85525522pasti__e
pastil85018322pasti_l_
pastils94416172pasti_ls
pastime114611972pasti_me
apostilles1244043apostilles
article9310923_article
astilbes1044733_astilbes
bastiles10313353bastiles
canaille1048413canaille
canticle1239703canticle
castable121613973castable
castle84918963cast__le
distill83011323distill_
distilled1147183distilled
distiller1046673distiller
distills9319043distills
faille93414743fa__ille
fascicle1554633fascicle
hastily133010663hasti_ly
hostile10312553hosti_le
instill789063instill_
instilled1045303instilled
instiller944953instiller
instills867353instills
latilla737953la_tilla
manille92613273ma_nille
mantilla1048163mantilla
marseille1154063marseille
mastiche1547173mastiche
mastlike1437863mastlike
mistitle1038523mistitle
nastily103011033nasti_ly
ostiole739013_ostiole
panicle11129983pa_nicle
pantie84326473panti__e
pantiled113111593pantiled
pantiles103617153pantiles
pantofle1364553pantofle
papilla11127913pa_pilla
papillae12137023pa_pillae
partial92616263partial_
partially1449033partially
partials101911963partials
particles1339803particles
partite9317133parti_te
passable12310633passable
passive12239593passi_ve
pastalike1546723pastalike
paste74932953past___e
pastel85918713past_el_
pastels95215183past_els
pasticci1443823pasticci
pastiches1637453pastiches
pastier94320383pasti_er
pasties94529813pasti_es
pastiest103319553pastiest
pastimes123611903pastimes
pastina93914593pasti_na
pastinas103712153pastinas
pasting103826553pasti_ng
pastis84924323pasti__s
pastises103616053pastises
pastitso1043623pastitso
pastorale1147323pastorale
pastorly1345783pastorly
pasture9311463past_ure
patella938953pa_tella
patellae1047623pa_tellae
patinae95414403pa_tinae
patine85328123pa_ti_ne
pattie84020963patti__e
pesthole1347553pesthole
pestle83215843pest__le
petiole9311303p_etiole
pistil83915073pisti_l_
pistillate1245443pistillate
pistils93314303pisti_ls
pistole92414313pist_ole
pistolled1255173pistolled
plasticly1644763plasticly
plastique2043043plastique
possible1245813possible
postally13310273postally
posthole1339533posthole
postiche1547793postiche
postie84123963posti__e
postique1945873postique
pustule937683pust_ule
ramtilla1054733ramtilla
spadille1145193spa_dille
stifle93611903__stifle
stile54931573__sti_le
still54922083__still_
stilled83314793__stilled
stiller73414303__stiller
stills64118573__stills
stilly93714093__stilly
tactile9310613tacti_le
taille63116923ta__ille
tastable101511973tastable
tastily103311643tasti_ly
testicle1037443testicle
wastable131410453wastable

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621157.56319325.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.02922255.7
 
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.