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

278 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
medick15401013(None) 
medic104619651medic_
medicks16368411medicks
medico113711161medico
medics114115351medics
bedeck1536212bedeck
bedtick1645232bedtick
detick1339382detick
dick116432382__dick
edict84722282_edict
media84721712medi_a
mediacy1536142mediacy
mediad104313712mediad
mediae94217412mediae
medial93819862medial
median94117542median
medias93620782medias
medical12312512medical
medicos12339832medicos
medii84513492medi_i
medina94114092medina
medium113711622medium
medius93613282medius
melic94722332melic_
mesic93617862mesic_
mick126333432m__ick
modica11310062modica
musick14408702musick
redock134311542redock
addict10711203addict
aedile73716653aedile
aedine73218393aedine
amebic1239113amebic_
amidic114012863amidic_
antick124814583antick
asdic83814093asdic_
asdics9439863asdics
beck126226573be__ck
bedecks1635793bedecks
bedim10313833bedi_m
bedims1149593bedims
bedrock1645643bedrock
bedticks1774163bedticks
bemock1636173bemock
benedick1743093benedick
bodice11711423bodice
brick134618153_brick
cedi74919273cedi__
ceding104014803ceding
cedis84317083cedi_s
ceric94023093ceric_
chick165419133_chick
click135217953_click
comedic14158633comedic_
crick135118753_crick
deck115827753__deck
deduce1079253deduce
deduct10610793deduct
deice84320033de_ice
delict94320333delict
demic105119193demic_
depict113514793depict
derrick1435803derrick
deticks1437353deticks
device124512163device
dice75841893__dice
dicks125824693__dicks
dicky154816243__dicky
dink97137803__dink
dirk96326833__dirk
disk96625833__disk
dock116228743__dock
duck115929173__duck
edicts94911703_edicts
edify12308563_edify
edile64819493_edile
edit54934863_edi_t
edits65819033_edits
educe84313453_educe
educt85017103_educt
emetic10614453emetic_
emetics11610723emetics
emic86422753_emic_
epic86921303_epic_
epics95014283_epics
erica7316543_erica
etic66123953_etic_
evict104417143_evict
feck134923433fe__ck
fetich1479693fetich
flick145017213_flick
geck115721993ge__ck
genic85119393genic_
geodic1048003geodic_
geoduck1542463geoduck
gweduck1841483gweduck
heck135826493he__ck
hemic125718623hemic_
herdic123112303herdic_
herdics13249523herdics
hick135530303__hick
hoick145210683_hoick
homesick1944413homesick
ick97329323___ick
imidic11358203imidic_
indict93115573indict
iodic84816753iodic_
keck94920713ke__ck
kick96026063__kick
klick105311433_klick
lexica1536103lexica
lick106935073__lick
limerick1645403limerick
ludic82912803ludic_
mack125733643m__ack
maffick2143523maffick
mafic125615463mafic_
magic105818653magic_
magics115311613magics
maledict1346673maledict
malic94525653malic_
malice104818483malice
manic94629433manic_
manics103919933manics
maverick1944033maverick
mecca1139933me_cca
med66146743med___
medaka1336343medaka
medal86221323med_al
medals94218043medals
meddle103312763meddle
medfly1535223medfly
medials103914733medials
medians103214213medians
mediant103516703mediant
mediate103415213mediate
medicaid1445773medicaid
medicals1349363medicals
medicant13910823medicant
medicare1347483medicare
medicate13513243medicate
medicide1447713medicide
medicine1349543medicine
medigap1374623medigap
medinas103411463medinas
mediocre1343473mediocre
mediums12308723mediums
medivac1554693medivac
medivacs1644003medivacs
medlar93010463medlar
medley1298333medley
meds75735363med__s
medusa936293medusa
meek105624833me__ek
megilp1135833megilp
meiny104015413me_iny
melding113414273melding
melodic1238543melodic_
melodica1344983melodica
menace103216943menace
mendigo11506333mendigo
mending114018683mending
menial84223033menial
meninx1538703meninx
menisci1144773menisci
mensch13387083mensch
merc87225623me_rc_
merch125417963me_rch
mercs96020453me_rcs
mercy125916183me_rcy
merino8315093merino
merit7339183meri_t
merits8320873merits
merk106027943me__rk
mesial84818083mesial
mesian84315503mesian
metical11315363metical
metier83517693metier
meting94320593meting
metis75025903meti_s
metric10314673metric_
metrics11312363metrics
mewing123914203mewing
mic77647643m__ic_
mica86428253m__ica
mice87442233m__ice
micks135525373m__icks
mics87435153m__ics
midi75628473midi__
midis85923413midi_s
milk105028473m__ilk
mimic111414323mimic_
mimics1289363mimics
mink106636523m__ink
mirk106729503m__irk
miskick1435613miskick
mock126429443m__ock
modi76826313modi__
modicum1445073modicum
modify1537173modify
modish123813543modish
muck125727853m__uck
mudpack1843593mudpack
mudrock1644353mudrock
mujik1866103muji_k
music94316403music_
musicks15297053musicks
musics103911783musics
myrica1336823myrica
neck105423663ne__ck
nick106627603__nick
nudnick1452863nudnick
odic74920573_odic_
peck125730683pe__ck
pedicab1446693pedicab
pedicel1237813pedicel
pedicle1238963pedicle
pick125933813__pick
predict12315323predict
prick134317503_prick
pudic104614563pudic_
quick204311063_quick
rebeck14419913rebeck
reck106130563re__ck
recock145112723recock
redact9419043redact
redbrick1742653redbrick
redia65524483redi_a
rediae74221993rediae
redial74923113redial
redias74523603redias
redid74922393redi_d
reding83825563reding
redip87816963redi_p
redips93713843redips
redipt94116743redipt
redneck1445113redneck
redocks14409933redocks
reduce9713253reduce
reink95518093re_ink
relic74623363relic_
relics84517903relics
relict83623903relict
relink104415923relink
relock124713523relock
repack142412163repack
rerack122513163rerack
retack122612823retack
rick107334653__rick
seasick1346193seasick
sedile73517233sedile
seduce9610023seduce
sepic94617053sepic_
shtick15308013shtick
sick106435573__sick
slick115520523_slick
snick114416013_snick
sodic84917483sodic_
spick134519073_spick
stick115121563_stick
strick124813203strick
tedium9269873tedium
telic76019823telic_
thick145613353_thick
tick106231223__tick
trick115420693_trick
undock1337703undock
unpick1446903unpick
uptick1436763uptick
verdict1339583verdict
vesica11157913vesica
wedlock1744553wedlock
wick135726303__wick
wrick144013393_wrick
xenic144114643xenic_
xeric144315663xeric_
zaddick2442993zaddick
zebeck23255203zebeck

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162786.36017722.6
3Display Results2782780.0803475.0
 (SQL Overall)1786912786.58027156.7
 
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.