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

96 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
pastilles114870(None) 
bastilles1147361bastilles
pastille1038941pastille_
apostilles1244042apostilles
astilbes1044732_astilbes
bastiles10313352basti_les
bastille1048002bastille_
pantiles103617152panti_les
particles1339802particles
pastiches1637452pastiches
pasties94529812pasti__es
pastils94416172pasti_l_s
pastimes123611902pasti_mes
pastises103616052pasti_ses
apostille1144243apostille_
articles10310243_articles
astilbe945653_astilbe_
bastile9313913basti_le_
canailles1148273canailles
canticles1339183canticles
castles94917733cast__les
distilled1147183distilled
distiller1046673distiller
distillers1145133distillers
distills9319043distill_s
failles102914133fa__illes
fascicles1664263fascicles
hostiles11312213hosti_les
instilled1045303instilled
instiller944953instiller
instillers1043663instillers
instills867353instill_s
latillas847363la_tillas
manilles102312603ma_nilles
mantillas1147043mantillas
marseilles1253533marseilles
mastiches1647333mastiches
mastixes1738253masti_xes
mistitles1147953mistitles
nasties73520493nasti__es
ostioles839273_ostioles
panicles121010113pa_nicles
panties94230933panti__es
pantile93918483panti_le_
pantiled113111593panti_led
pantofles1474863pantofles
partials101911963partial_s
partible1238063partible_
particle1239533particle_
parties93230863parti__es
passible1237693passible_
passives13228823passi_ves
pastellist1255573pastellist
pastels95215183past_el_s
pastes85233913past___es
pastiche1546933pastiche_
pastie85525523pasti__e_
pastier94320383pasti__er
pastiest103319553pasti__est
pastil85018323pasti_l__
pastime114611973pasti_me_
pastinas103712153pasti_nas
pastiness112312353pastiness
pastis84924323pasti___s
pastitsos1142893pastitsos
pastless102411203past_less
pastorales1247143pastorales
pastries101517423past_ries
pastures10311963past_ures
patellas1039103pa_tellas
patines95225763pa_ti_nes
patsies93919483patsi__es
patties93425143patti__es
pestholes1448233pestholes
pestles93217693pest__les
petioles10311643p_etioles
pistils93314303pisti_l_s
pistoles102514723pist_oles
pistolled1255173pistolled
plastiques2142813plastiques
postholes14410453postholes
postiches1648223postiches
posties93128813posti__es
postiques2045833postiques
pustules1038443pust_ules
ramtillas1174193ramtillas
spadilles1244993spa_dilles
stifles103013393__stifles
stiles64328773__sti_les
stilled83314793__stilled
stiller73414303__stiller
stillest8311073__stillest
stills64118573__still_s
tailles72516473ta__illes
testicles1146773testicles
vastities1248933vastities

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.453394461.4
2DLD Change Limit148641966.82621775.7
3Display Results96960.0332909.1
 (SQL Overall)178691967.31224438.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.