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

172 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
merc8722562(None) 
marc87034621marc
merch125417961merch
mercs96020451mercs
mercy125916181mercy
mere67244441mere
merk106027941merk
merl65830971merl
aero45435342aero
aery77231682aery
amerce10310512amerce
arc510250902_arc
berg75425542berg
berk105929842berk
berm86732752berm
cerci93716392cerci
cere66741472cere
ceric94023092ceric
cero66329452cero
dere56845902dere
derm76031892derm
eery76129622eery
emery104814332emery
emic86422742emic
er28345142_er_
era35741502_era
ere36352772_ere
erg45531072_erg
ern35738352_ern
err35626532_err
ers36046282_ers
fer66646122fer_
fere76342232fere
fern76129322fern
germ75428962germ
her66547812her_
herb94730962herb
herd84933062herd
here76447102here
herl75834552herl
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
jerk154920132jerk
kerb104322712kerb
kerf115827462kerf
kern85326212kern
mac78053922m_ac
mar57965942mar_
mara67444562mara
march125622892march
marcs95726622marcs
mare64759322mare
mark105138052mark
marl66341612marl
mars66261862mars
mart66865972mart
me47748332me__
mead75531602mead
meal65643172meal
mean65538082mean
meat66359602meat
mecca1139932mecca
med66146742me_d
medic104619652medic
meds75735362meds
meed74934702meed
meek105624832meek
meet65350552meet
meg66040952me_g
mega77620872mega
megs75530632megs
mel56047482me_l
meld75830472meld
melic94722332melic
mell64935612mell
mels65941532mels
melt65752892melt
mem77943472me_m
meme85330552meme
memo85924792memo
mems85931502mems
men59252842me_n
mend75334022mend
meno66031352meno
menu65130222menu
meou65325862meou
meow95117882meow
mercer105214202mercer
merces105720742merces
merde84320122merde
merer75126232merer
meres75143572meres
merge84523682merge
merit7339182merit
merks114722402merks
merle75824372merle
merls77423902merls
merry104721482merry
mesa67025482mesa
mesh96823002mesh
mesic93617862mesic
mess65932432mess
met56072432me_t
meta65932412meta
mete64438132mete
meth95827842meth
metre74821302metre
metric10314672metric
metro74718802metro
mew86137732me_w
mewl95618322mewl
mews96629332mews
meze154420902meze
mic77647632m_ic
mir57046762mir_
mire66748222mire
miri66730362miri
mirk106729492mirk
mirs66940562mirs
miry96326742miry
moc77845082m_oc
mor56855002mor_
mora66641272mora
more67154522more
morn66237562morn
mors65950062mors
mort66758832mort
mura65633292mura
mure65941332mure
murk105527252murk
murr65225132murr
myc106519502m_yc
narc67127952narc
nerd56624942nerd
omer67028392omer_
omers76923192omers
orc57034922_orc
pec76744412pe_c
per56353092per_
perch124518832perch
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
rec55645462re_c
sec55945322se_c
ser36752402ser_
sera46141392sera
serac75925202serac
sere46153472sere
serf76340112serf
sers45746652sers
smerk115412722smerk
terce75721842terce
term66233152term
tern46134802tern
torc66333352torc
vera76828842vera
verb96224872verb
vert77249372vert
very108025642very
were76238332were
wert79749822wert
xeric144315662xeric
yerk116222082yerk
zerk175319252zerk
zero134822462zero

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 Filter178691298720.0632836365.1
2DLD Change Limit298721720.95331345.2
3Display Results1721720.0463739.1
 (SQL Overall)1786911721.062168258.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.