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

129 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
marchese1535891(None) 
marches143921171marches_
marchesa15346881marchesa
marchesi15337321marchesi
arches114822042_arches_
larches124416442larches_
maches134827232ma_ches_
machete14310882ma_chete
manches143818622manches_
marched153813402marche_d
marchen143312072marche_n
marcher143912972marche_r
marchers153710812marchers
marshes123615372marshes_
matches143219782matches_
merches144013762merches_
parches143720002parches_
parchesi15358212parchesi
achene11313813_a_chene
aches106132293_a_ches_
archaise1348473_archaise
archean1269123_archean
arched125717323_arche_d
archer115016243_arche_r
archers124414573_archers
archery15478063_archery
archfoe1544723_archfoe
archine125817053_archine
archive154610483_archive
archness1337513_archness
baches135426943ba_ches_
barghest1447913barghest
batches144019613batches_
birches143412323birches_
braches144621223braches_
caches137926913ca_ches_
carcase11312733carc_ase
caroches15710693caroches_
catches144320763catches_
curches143512743curches_
demarches1745913demarches_
earaches13411303earaches_
farces115223323farc_es_
farcies125317883farcies_
farthest1499863farthest
gauchest1436293gauchest
harshest14310193harshest
hatches153420273hatches_
inarches1358043inarches_
laches116528343la_ches_
larchen12479623larche_n
latches123320123latches_
lurches123311663lurches_
macchie1647193macch_ie
maces97139963ma_c_es_
mache125925303ma_ch__e
machetes1539633ma_chetes
machine14313493ma_chine
machos135217493ma_chos_
machree1438513ma_chree
machrees1545503ma_chrees
machs125722563ma_ch_s_
macles107023223ma_cles_
manche133515103manch__e
manchet143317773manche_t
manchets15269573manchets
marbleise1343483marbleise
marbles114516653marbles_
marcel103714853marc_e_l
marcels113212373marc_els
march125622893march___
marching164312193marching
marchlike2044793marchlike
marchpane1843693marchpane
marcs95726623marc__s_
mares76457633mar__es_
marges94525713mar_ges_
marines93928013marines_
marishes13512553marishes_
marliest102415183marliest
marquee18218583marque_e
marquees19206243marquees
marques182610863marques_
marquess19204953marquess
marquise19206173marquise
marries93825283marries_
marse76231153mar___se
marses84827113mar_ses_
marshiest1438093marshiest
mashes115030003ma_shes_
matched153513963matche_d
matcher143214283matche_r
matchers153012433matchers
matchless1644673matchless
menarches1646683menarches_
merces105720743merc_es_
mercies113817563mercies_
miches134320733m_iches_
mischose1547253mischose
mooches143714453mooches_
morpheme1744053morpheme
mouches143815963mouches_
muches134718993m_uches_
mulches143210673mulches_
munches144215793munches_
mutches143314283mutches_
naches114622413na_ches_
narcose95910383narc_ose
oraches124216473oraches_
parched154013693parche_d
parcheesi16233763parcheesi
parchesis16318203parchesis
parchisi15368923parchisi
parclose1247243parclose
patches143320383patches_
perches143717953perches_
porches143815673porches_
purchase1545293purchase
ranches123620113ranches_
ratches123620463ratches_
searches132112903searches_
smirches1535993smirches_
starches131912913starches_
taches114224173ta_ches_
torchere1347673torchere
torches123715433torches_
tracheae1349103tracheae
watches153017373watches_
watcheye19104273watcheye

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621298.23617746.7
3Display Results1291290.0462804.3
 (SQL Overall)1786911298.43521184.5
 
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.