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

232 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
medicks1636841(None) 
medick154010131medick_
medicos12339831medicos
medics114115351medic_s
bedecks1635792bedecks
bedticks1774162bedticks
deticks1437352deticks
dicks125824692__dicks
edicts94911702_edicts
medials103914732medials
medians103214212medians
medias93620782medi_as
medic104619652medic__
medical12312512medical
medicals1349362medicals
medico113711162medic_o
medinas103411462medinas
mediums12308722mediums
medius93613282medi_us
micks135525372m__icks
musicks15297052musicks
redocks14409932redocks
addicts1176013addicts
aediles83413903aediles
anticks134612253anticks
asdics9439863asdic_s
becks135522013be__cks
bedeck1536213bedeck_
bedims1149593bedi_ms
bedrocks1745333bedrocks
bedtick1645233bedtick_
bemocks1735373bemocks
benedicks1842563benedicks
bodices12710593bodices
bricks144614623_bricks
cedis84317083cedi__s
chicks175317593_chicks
clicks145315113_clicks
codices12512583codices
cricks144316053_cricks
decks124822193__decks
deduces1168793deduces
deducts1166593deducts
deices94119373de_ices
delicts104012253delicts
depicts12358463depicts
derricks1544433derricks
detick1339383detick_
devices133212583devices
dices86434243__dices
dick116432383__dick_
dicky154816243__dicky
dinks105927953__dinks
dirks105619523__dirks
disks105417473__disks
docks126022313__docks
ducks124823213__ducks
edict84722283_edic_t
ediles74016983_ediles
edits65819033_edi_ts
educes94011953_educes
educts9439893_educts
emetics11610723emetic_s
epics95014283_epic_s
ericas8315463_ericas
evicts11368553_evicts
fecks145417853fe__cks
flicks154512993_flicks
gecks125117093ge__cks
geoducks1642283geoducks
gweducks1941443gweducks
hecks145220653he__cks
helices12313723helices
herdics13249523herdic_s
hicks145322173__hicks
hoicks15378283_hoicks
indices103513443indices
indicts103210723indicts
kecks105416573ke__cks
kicks104420083__kicks
klicks11468723_klicks
licks115325393__licks
limericks1744403limericks
macks135127603m__acks
mafficks2243173mafficks
magics115311613magic_s
maledicts1443393maledicts
malices114316623malices
manics103919933manic_s
mavericks2043183mavericks
meccas1239493me_ccas
medaka1336343med_aka
medakas1435763medakas
medals94218053med_als
meddles113213253meddles
media84721713medi__a
mediacies1447183mediacies
mediacy1536143mediacy
mediad104313713medi_ad
mediae94217413medi_ae
medial93819863medi_al
median94117543medi_an
mediant103516703mediant
mediants11299493mediants
mediate103415213mediate
mediates112814063mediates
medicaid1445783medicaid
medicaids1544003medicaids
medicant13910823medicant
medicants1466783medicants
medicare1347483medicare
medicares1446873medicares
medicate13513243medicate
medicates14312113medicates
medicide1447713medicide
medicides1556583medicides
medicine1349543medicine
medicines1447903medicines
medigap1374623medigap
medigaps1463883medigaps
medii84513493medi__i
medina94114093medi_na
mediocre1343473mediocre
medium113711623medi_um
medivac1554693medivac
medivacs1644003medivacs
medlars10259443medlars
medleys13115333medleys
meds75735363med___s
medusas1036213medusas
megilps1233563megilps
melic94722333melic__
melodicas1444853melodicas
menaces112715523menaces
mendigos12425213mendigos
mendings12338303mendings
menials94015683menials
meniscus1243773meniscus
merces105720743me_rces
mercies113817563mercies
mercs96020453me_rc_s
merinos9311983merinos
merises93421423merises
merisis93213173merisis
merits8320873meri_ts
merks114722403me__rks
mesic93617863mesic__
methinks1775193methinks
meticais1248183meticais
metical11315363metical
meticals12310763meticals
metiers93312843metiers
metis75025903meti__s
metrics11312363metric_s
micas96823053m__icas
mick126333433m__ick_
mics87435153m__ic_s
midis85923413midi__s
milks115020583m__ilks
mimics1289363mimic_s
minks115829273m__inks
mirks115122143m__irks
miskicks1544763miskicks
mocks135023823m__ocks
modica11310063modic_a
modicum1445073modicum
modicums1543483modicums
mucks134622643m__ucks
mudpacks1943233mudpacks
mudrocks1743993mudrocks
mujiks1964023muji_ks
murices112612283murices
musick14408703musick_
musics103911783music_s
myricas1436753myricas
necks115119333ne__cks
nicks114920493__nicks
nudnicks1542403nudnicks
pecks135724433pe__cks
pedicab1446693pedicab
pedicabs1544593pedicabs
pedicel1237813pedicel
pedicels1336253pedicels
pedicle1238973pedicle
pedicles1338683pedicles
picks135226143__picks
predicts1339613predicts
pricks144414263_pricks
quicks21389303_quicks
radices102314263radices
rebecks15288013rebecks
recks115625133re__cks
recocks154711463recocks
redacts10510943redacts
redbricks1842303redbricks
redials84416883redials
redias74523603redi_as
redips93713843redi_ps
rednecks1544013rednecks
redock134311543redock_
reduces10513343reduces
reinks105012153re_inks
relics84517903relic_s
relicts94414593relicts
relinks114510223relinks
relocks134411293relocks
repacks15269543repacks
reracks132310533reracks
retacks132210713retacks
ricks115126133__ricks
seduces1069283seduces
shticks16356963shticks
sicks115127623__sicks
slicks124816113_slicks
snicks124312473_snicks
spicks144814993_spicks
sticks125118613_sticks
stricks134310693stricks
tedious838443tedious
tediums10266973tediums
thicks154511993_thicks
ticks115823293__ticks
tricks125319013_tricks
undocks1436163undocks
unpicks1545183unpicks
upticks1535153upticks
verdicts1446013verdicts
wedlocks1844393wedlocks
wicks144619363__wicks
wricks154610623_wricks
yoicks15375933_yoicks
zebecks24274193zebecks

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272326.17321711.8
3Display Results2322320.0763052.6
 (SQL Overall)1786912326.65526850.6
 
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.