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

93 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
mastiches164733(None) 
mastiche1547171mastiche_
pastiches1637451pastiches
masticates1449842masticates
mastics112614782mastic__s
mastixes1738252masti_xes
matches143219782ma_t_ches
mustaches16166052mustaches
pastiche1546932pastiche_
postiches1648222postiches
affiches1945233_affiches
aitches123014363_ait_ches
articles10310243_articles
astilbes1044733_astilbes
attaches13137723_attaches
babiches1735253ba_biches
bastiles10313353basti_les
bastilles1147363bastilles
batches144019613ba_t_ches
caliches153812263ca_liches
canticles1339183canticles
catches144320773ca_t_ches
distichs1447633distich_s
fascicles1664263fascicles
fetiches1636953_fetiches
hashishes1444393hashishes
hatches153420273ha_t_ches
justices1737523justic_es
latches123320123la_t_ches
latices9313763la_tic_es
lattices1038383lattic_es
maches134827233ma___ches
malices114316623ma_lic_es
manches143818623ma__nches
manticores1445753manticores
mantises10317923manti_ses
marches143921173ma__rches
marishes13512553ma_rishes
mashes115030003mas___hes
mashies12318253mashi__es
massacres1344693massacres
massicots1343843massicots
masteries111018493masteries
mastic103119173mastic___
masticate13411283masticate
masticated1548233masticated
mastiffs1644233masti_ffs
mastitides1345833mastitides
mastitis1039103masti_tis
matched153513963ma_t_ched
matcher143214283ma_t_cher
matchers153012433ma_t_chers
matinees102110423ma_tinees
matrices12312083matric_es
mestinoes1157313mestinoes
mestizoes2064173mestizoes
miches134320733m___iches
misteaches1744993misteaches
mistimes12612613misti_mes
mistitles1147953mistitles
mistouches1743393mistouches
mortices12711563mortic_es
moustaches1763813moustaches
mustache15185283mustache_
mustached17164833mustached
mutches143314283m_ut_ches
mysticetes1753053mysticetes
mystics14279103mystic__s
mystifies1745883mystifies
mystiques2342423mystiques
nasties73520493nasti__es
nautches1336083naut_ches
ostriches1446633_ostriches
particles1339803particles
pasticheur1751743pasticheur
pasticheurs1851423pasticheurs
pasties94529813pasti__es
pastilles1148703pastilles
pastimes123611903pasti_mes
pastises103616053pasti_ses
patches143320383pa_t_ches
pistaches1646673pistaches
postiche1547793postiche_
potiches1539203_potiches
ratches123620463ra_t_ches
restitches1545063restitches
seiches12513813__seiches
stichs114511653__stich_s
stitches131410593__stitches
testicles1146773testicles
unstitches1543563unstitches
vastities1248933vastities
watches153017373wa_t_ches

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 Limit148641937.01621186.0
3Display Results93930.0761223.7
 (SQL Overall)178691937.49823831.8
 
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.