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

45 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
parchesis1631821(None) 
parcheesis17174051parcheesis
parchesi15358211parchesi_
parchisis16318571parchisis
marchesi15337322marchesi_
pachisis15268822pa_chisis
parcheesi16233762parcheesi_
parches143720002parche__s
parchisi15368932parchisi_
paresis93315092par__esis
anthesis11312503_anthesis
aphesis12610513_a_phesis
archeries14411223_archeries
archers124414573_arche_rs
arches114822043_arche__s
archness1337513_archnes_s
ascesis938373_asc_esis
barghests1543313barghests
catechesis1743243catechesis
larches124416453larche__s
marchers153710813marche_rs
marches143921173marche__s
marchesa15346883marches_a
marchese15358913marches_e
narcosis10388053narc_osis
pachisi14329523pa_chisi_
paralysis1447313paralysis
paraphysis2064533paraphysis
parcels113712663parc_e_ls
parched154013693parche__d
parchments1944983parchments
parcloses1347963parcloses
parenthesis1654053parenthesis
pareses94718883par__eses
parhelia1346713par_helia
parhelic1547093par_helic
patchers153413303patche_rs
patches143320383patche__s
paychecks2542243paychecks
perchers153611523perche_rs
perches143717953perche__s
porches143815673porche__s
prothesis1449433prothesis
psychosis1946793psychosis
purchases1645633purchases

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 Limit148641456.84321721.6
3Display Results45450.0162812.5
 (SQL Overall)178691457.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.