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

108 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
marchesi1533732(None) 
marches143921171marches_
marchesa15346881marchesa
marchese15358911marchese
parchesi15358211parchesi
arches114822042_arches_
larches124416442larches_
maches134827232ma_ches_
manches143818622manches_
marched153813402marche_d
marchen143312072marche_n
marcher143912972marche_r
marchers153710812marchers
marshes123615372marshes_
matches143219782matches_
merches144013762merches_
parcheesi16233762parcheesi
parches143720002parches_
parchesis16318212parchesis
parchisi15368932parchisi
aches106132293_a_ches_
archean1269123_archean
arched125717323_arche_d
archer115016243_arche_r
archers124414573_archers
archery15478063_archery
archness1337513_archness
baches135426943ba_ches_
barghest1447913barghest
batches144019613batches_
birches143412323birches_
braches144621223braches_
caches137926913ca_ches_
caroches15710693caroches_
catches144320763catches_
curches143512743curches_
demarches1745913demarches_
earaches13411303earaches_
farces115223323farc_es_
farcies125317883farcies_
farthest1499863farthest
gauchest1436293gauchest
harshest14310193harshest
hatches153420273hatches_
inarches1358043inarches_
laches116528343la_ches_
larchen12479623larche_n
latches123320123latches_
lurches123311663lurches_
maces97139963ma_c_es_
mache125925303ma_che__
machete14310883ma_chete
machos135217493ma_chos_
machs125722563ma_ch_s_
macles107023223ma_cles_
manche133515103manche__
manchet143317773manche_t
manchets15269573manchets
maravedi1442803maravedi
marbles114516653marbles_
marcel103714853marc_e_l
marcels113212373marc_els
march125622893march___
marching164312193marching
marcs95726623marc__s_
mares76457633mar__es_
marges94525713mar_ges_
marines93928013marines_
marishes13512553marishes_
marliest102415183marliest
marques182610863marques_
marquess19204953marquess
marries93825283marries_
marses84827113mar_ses_
marshiest1438093marshiest
mashes115030003ma_shes_
matched153513963matche_d
matcher143214283matche_r
matchers153012433matchers
matchless1644673matchless
menarches1646683menarches_
merces105720743merc_es_
mercies113817563mercies_
miches134320733m_iches_
mooches143714453mooches_
mouches143815963mouches_
muches134718993m_uches_
mulches143210673mulches_
munches144215793munches_
mutches143314283mutches_
naches114622413na_ches_
narcissi1043303narcissi
oraches124216473oraches_
pachisi14329523pa_chisi
parched154013693parche_d
parcheesis17174053parcheesis
parchisis16318573parchisis
patches143320383patches_
perches143717953perches_
porches143815673porches_
ranches123620113ranches_
ratches123620463ratches_
searches132112903searches_
smirches1535993smirches_
starches131912913starches_
taches114224173ta_ches_
torches123715433torches_
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.203880251.2
2DLD Change Limit1461621087.39019778.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.