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 “march” with Change Limit: [1] [2]

(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
march12562289(None) 
arch98628441_arch
larch105919791larch
mach116134471ma_ch
marc87034621marc_
marcs95726621marcs
marsh105320851marsh
match125621101match
merch125417961merch
parch125123001parch
aargh96314082aargh
anarch11310392anarch
arc510250902_arc_
arco68331542_arco
arcs67834782_arcs
bach116131392ba_ch
barca91319432barca
batch124620102batch
birch124914022birch
brach126123302brach
caroch13911762caroch
catch125120372catch
curch124415412curch
each95530582ea_ch
earth85023052earth
eparch13258422eparch
exarch18196172exarch
farce104925322farce
farci105919312farci
farcy135217092farcy
garth94720222garth
harsh116418052harsh
hatch135719592hatch
inarch1139162inarch
laich105920712laich
latch104620462latch
lurch104814632lurch
mac78053922ma_c_
mace87345782ma_ce
mache125925302ma_che
macho126120152ma_cho
machs125722562ma_chs
mack125733642ma_ck
macro94718172macro
macs86742502ma_cs
manche133515102manche
mar57965942mar__
mara67444562mar_a
maraca10314152maraca
maras75443282maras
marcel103714852marcel
marched153813402marched
marchen143312072marchen
marcher143912972marcher
marches143921172marches
mare64759322mar_e
mares76457632mares
marge85328332marge
maria75032882maria
marish114319052marish
mark105138052mar_k
marka114620792marka
marks115933482marks
marl66341612mar_l
marls75535162marls
marly106925612marly
marry104821692marry
mars66261862mar_s
marse76231152marse
marshy14558332marshy
mart66865972mar_t
marts77442232marts
marvy135014032marvy
mash96039392ma_sh
math95437442ma_th
merc87225622merc_
mercs96020452mercs
mercy125916182mercy
mesarch1445532mesarch
milch124413372milch
mirth106418892mirth
monarch1445952monarch
mooch125313612mooch
morph121712512morph
mouch124715802mouch
much115224032m_uch
mulch124012972mulch
munch124917102munch
mutch125016172mutch
myrrh1337092myrrh
narc67127952narc_
narco76718242narco
narcs76122022narcs
natch105018222natch
nomarch1445342nomarch
orach105219232orach
patch125221222patch
perch124518832perch
porch125918622porch
ranch105019792ranch
ratch104221362ratch
sauch104918772sauch
search113312422search
smirch1356462smirch
starch113013202starch
tach96132752ta_ch
torch107420932torch
watch135617062watch

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001081.82629463.3
3Display Results1081080.0303600.0
 (SQL Overall)1786911081.94991683.4
 
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.