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

188 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
medalled124689(None) 
medaled113411611meda_led
metalled1148981metalled
pedalled1246921pedalled
begalled1236022begalled
bemedalled1642072bemedalled
malled94626112m__alled
measled10339302me_asled
medallic1345112medallic
meddled123210032med_dled
melled95023022me__lled
metaled102913882meta_led
modelled1236432modelled
muralled1136422muralled
pedaled113711882peda_led
pedaller1136092pedaller
petalled1138692petalled
recalled11310802recalled
redialled1145882redialled
sepalled1156902sepalled
appalled1344813appalled
balled94926893__balled
becalmed1534813becalmed
bedabbled1442543bedabbled
bedamned1434583bedamned
bedaubed1443183bedaubed
bedazzled2142083bedazzled
befallen1344033befallen
belled94626183be__lled
bemedaled1543313bemeda_led
bevelled14327793bevelled
bewailed1435343bewailed
caballed1337163caballed
called94126733__called
canalled1139583canalled
celled94420323ce__lled
dalles74222063__dalles
dallied93713613__dallied
derailed102410403derailed
desalted1038313desalted
detailed10319873detailed
devalued1335013devalued
devilled1336743devilled
dialled9510133_dialled
dilled84122223__dilled
dolled83518073__dolled
dulled84719423__dulled
eagled82914043_e_agled
emailed10359213_emailed
embalmed1544263embalmed
empaled12288953empa_led
enabled102510633_enabled
equalled1834863equalled
exalted1537393_exalted
eyeballed1542233eyeballed
felled103720303fe__lled
fenagled13184853fenagled
galled84622863__galled
gelled84718893ge__lled
healed105121443he_a_led
helled104024703he__lled
heralded1335433heralded
inwalled1275773inwalled
jelled144916063je__lled
jewelled1934333jewelled
lalled74218753__lalled
levelled12327443levelled
macled116718113m__acled
mailed95326753m__ailed
malfed12369763m__alfed
mallee84525593m__allee
mallei84414633m__allei
mallet84433053m__allet
malted94819863m__alted
manacled1336453manacled
marled95523163m__arled
mauled94817823m__auled
mealie82519813me_alie_
mealier93015903me_alier
mealies92821933me_alies
mealless10288363me_alless
measle83513223me_asle_
measles92412753me_asles
meated94222403me_a_ted
medaillon1242653medaillon
medal86221333meda_l__
medaling121912263medaling
medalist11414213medalist
medalling1346923medalling
medallion1244073medallion
medallist1246643medallist
medals94218053meda_l_s
meddle103312763med_dle_
meddler11319953med_dler
meddles113213253med_dles
medflies1435553medflies
medially14129323mediall_y
mediated123011873mediated
medley1298333med__ley
medulla1044713medull_a
medullae1143203medullae
medullar1143463medullar
medullas1144513medullas
medullated1442993medullated
megaplex2042513megaplex
melamed1249633mela_med
melded104714713me__lded
melted94219063me__lted
menaced122710093mena_ced
mendable131510583mendable_
mesally12119793mesall_y
metalhead1543203metalhead
metalised12310463metalised
metalized21412183metalized
metallic1247643metallic
metallized2265583metallized
metalloid1246203metalloid
mettled103510543me_ttled
mewled123710053me__wled
miauled1036663m_iauled
middled123311903mid_dled
milled94326173m__illed
misallied1246543misallied
miscalled1447443miscalled
misdialled1443013misdialled
modally1338403modall_y
modeled1139463mod_eled
modeller1136613modeller
muddled124111593mud_dled
mulled94721553m__ulled
muraled10410833mura_led
overalled1339073overalled
palled94625163__palled
pealed95322803pe_a_led
pearled10411543pe_arled
pedaler103410693peda_ler
pedalfer1443273pedalfer
pedalier1137603pedalier
pedallers1244763pedallers
peddled123410533ped_dled
pedicled1436463pedicled
perilled11410103perilled
petaled103614143peta_led
rebelled113110323rebelled
rebilled11318053rebilled
recaller1039323recaller
redacted12410243redacted
redated93120923reda_ted
reddled102912323red_dled
redialed10310793redialed
redrilled1145353redrilled
refallen1136213refallen
refelled122810163refelled
refilled12278673refilled
regaled93615963rega_led
remailed112411403remailed
renailed92512803renailed
repelled113111573repelled
repolled11359623repolled
rerolled93010043rerolled
resailed93613063resailed
retailed94113963retailed
retallied1046783retallied
revalued1237023revalued
revelled123712733revelled
rivalled1236093rivalled
sandalled1145903sandalled
sealed74328363se_a_led
sedated93714343seda_ted
sepaled10510593sepa_led
smelled103511853sme__lled
spalled103113133_spalled
squalled1835943squalled
stalled83515683_stalled
teazled17326833te_azled
thralled1245803thralled
totalled935843totalled
uncalled11810923uncalled
undulled1036993undulled
ungalled1078463ungalled
unwalled1288653unwalled
vealed103916323ve_a_led
vialled1156843_vialled
walled104021293__walled
wedeled1237783wed_eled
welled103820213we__lled
yelled104116253ye__lled
yodelled1334603yodelled

Search took 10 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 Limit1461621888.80016609.3
3Display Results1881880.0603133.3
 (SQL Overall)1786911889.01319825.9
 
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.