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

118 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
parchesi1535821(None) 
marchesi15337321marchesi
parcheesi16233761parcheesi
parches143720001parches_
parchesis16318211parchesis
parchisi15368931parchisi
arches114822042_arches_
larches124416452larches_
marches143921172marches_
marchesa15346882marchesa
marchese15358912marchese
pachisi14329522pa_chisi
parched154013692parche_d
parcheesis17174052parcheesis
parchisis16318572parchisis
patches143320382patches_
perches143717952perches_
porches143815672porches_
aches106132293_a_ches_
apaches143411843apaches_
archean1269123_archean
arched125717323_arche_d
archer115016243_arche_r
archers124414573_archers
archery15478063_archery
archness1337513_archness
baches135426943ba_ches_
barghest1447913barghest
batches144019613batches_
birches143412323birches_
braches144621223braches_
caches137926913ca_ches_
caroches15710693caroches_
catches144320773catches_
curches143512743curches_
earaches13411313earaches_
eparchies1646973eparchies_
eparchs14196243eparch_s_
farces115223323farc_es_
farcies125317883farcies_
farthest1499863farthest
gauchest1436293gauchest
harshest14310193harshest
hatches153420273hatches_
inarches1358043inarches_
laches116528353la_ches_
larchen12479633larche_n
latches123320133latches_
lurches123311663lurches_
maches134827233ma_ches_
manches143818623manches_
marched153813403marche_d
marchen143312073marche_n
marcher143912973marche_r
marchers153710813marchers
marshes123615373marshes_
matches143219783matches_
merches144013763merches_
naches114622413na_ches_
narcissi1043303narcissi
oraches124216473oraches_
paces96741113pa_c_es_
pachas135017143pa_chas_
pachisis15268823pa_chisis
paciest112917813pa_ciest
painches1588923painches_
panaches15310293panaches_
panoches1548123panoches_
parades104121473parades_
parcel103915473parc_e_l
parcels113712663parc_els
parch125123003parch___
parching164313053parching
parchment1846913parchment
parclose1247243parclose
pares77164483par__es_
pareses94718883pareses_
paresis93315093par__esis
parflesh1643753parflesh
parges94529543par_ges_
parhelia1346713par_helia
parhelic1547093par_helic
paries84742523par_ies_
parises94827193parises_
parishes13314763parishes_
parles86334413par_les_
paroles95025893paroles_
parries93925853parries_
parses85534703par_ses_
parties93230873parties_
parures9512693parures_
pashes115828393pa_shes_
patched153514623patche_d
patcher143515143patche_r
patchers153413303patchers
patchiest1638353patchiest
paunches1568173paunches_
paycheck2442553paycheck
peaches144120053peaches_
perched154713243perche_d
percher143313423perche_r
perchers153611523perchers
pinches144117933pinches_
pitches143617753pitches_
planches153111863planches_
poaches144416943poaches_
pooches143214163pooches_
pouches144116743pouches_
psyches1755803psyches_
punches144816133punches_
purchase1545293purchase
ranches123620113ranches_
ratches123620463ratches_
searches132112903searches_
starches131912913starches_
taches114224173ta_ches_
torches123715443torches_
watches153017373watches_

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.453394461.4
2DLD Change Limit1461621187.34319904.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.84222786.4
 
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.