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

107 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
pastiches163745(None) 
mastiches1647331mastiches
pastiche1546931pastiche_
postiches1648221postiches
mastiche1547172mastiche_
particles1339802particles
pasticheur1751742pasticheur
pasticheurs1851422pasticheurs
pasties94529812pasti__es
pastilles1148702pastilles
pastimes123611902pasti_mes
pastises103616052pasti_ses
patches143320382pa_t_ches
pistaches1646672pistaches
postiche1547792postiche_
potiches1539202p_otiches
affiches1945233_affiches
aitches123014363_ait_ches
articles10310243_articles
astilbes1044733_astilbes
attaches13137723_attaches
babiches1735253ba_biches
bastiles10313353basti_les
bastilles1147363bastilles
batches144019613ba_t_ches
caliches153812273ca_liches
canticles1339183canticles
catches144320773ca_t_ches
distichs1447633distich_s
fascicles1664263fascicles
fetiches1636953_fetiches
hashishes1444393hashishes
hatches153420273ha_t_ches
justices1737523justic_es
latches123320133la_t_ches
latices9313763la_tic_es
lattices1038383lattic_es
masticates1449843masticates
mastics112614783mastic__s
mastixes1738253masti_xes
matches143219783ma_t_ches
mustaches16166053mustaches
nasties73520493nasti__es
nautches1336083naut_ches
ostriches1446633_ostriches
painches1588913pa_inches
panaches15310293pa_naches
panfishes1737593panfishes
panicles121010113pa_nicles
panoches1548123pa_noches
panties94230933panti__es
pantiles103617153panti_les
parches143720003pa__rches
parishes13314753pa_rishes
parritches1743223parritches
particle1239533particle_
parties93230863parti__es
pashes115828393pas___hes
passives13228823passi_ves
pastes85233913past___es
pasticci1443823pastic_ci
pasticcio1553203pasticcio
pasticcios1693043pasticcios
pastie85525523pasti__e_
pastier94320383pasti__er
pastiest103319553pasti__est
pastille1038943pastille_
pastils94416173pasti__ls
pastime114611973pasti_me_
pastinas103712153pasti_nas
pastiness112312353pastiness
pastis84924323pasti___s
pastitsos1142893pastitsos
pastries101517423past_ries
pastures10311963past_ures
patched153514623pa_t_ched
patcher143515143pa_t_cher
patchers153413303pa_t_chers
patines95225763pa_ti_nes
patsies93919483patsi__es
patties93425143patti__es
paunches1568173pa_unches
pesticides1546723pesticides
pistache1545893pistache_
pitches143617753p_it_ches
plasticenes15124283plasticenes
plasticines15105433plasticines
plasticizes2495653plasticizes
plastics122412333plastic__s
plastiques2142813plastiques
porticoes1348253porticoes
posties93128813posti__es
postiques2045833postiques
potiche1438043p_otiche_
practices1557993practic_es
psyches1755803p_s_yches
putsches1535313p_utsches
ratches123620463ra_t_ches
restitches1545063restitches
seiches12513813__seiches
spastics1237503spastic__s
stichs114511653__stich_s
stitches131410593__stitches
testicles1146773testicles
unstitches1543563unstitches
vastities1248933vastities
watches153017373wa_t_ches

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411077.86018911.1
3Display Results1071070.0462326.1
 (SQL Overall)1786911078.35921377.1
 
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.