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

446 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
emailed1035921(None) 
mailed95326751_mailed
remailed112411401remailed
ailed66240282__ailed
availed1135972availed
bailed94726652_bailed
bewailed1435342bewailed
brailed103914012brailed
camailed1336552camailed
derailed102410402derailed
detailed10319872detailed
eagled82914042e_agled
email74715092email__
emails84412332email_s
empaled12288942empaled
enabled102510632enabled
ensiled82611432ensiled
entailed989522entailed
exiled144712462e_xiled
failed105421602_failed
flailed1137302flailed
hailed104122742_hailed
jailed144917422_jailed
macled116718112_macled
maile75232212_maile_
mailer84724182_mailer
mailes84329112_mailes
maimed114812662_maimed
malled94626102_malled
marled95523162_marled
mauled94817822_mauled
measled10339302measled
moiled94318862_moiled
nailed74021492_nailed
quailed1737822quailed
railed74727542_railed
remained112412892remained
renailed92512802renailed
resailed93613062resailed
retailed94113962retailed
sailed74327762_sailed
smiled93716432sm_iled
snailed83811922snailed
tailed74424662_tailed
trailed83415672trailed
unmailed11229762unmailed
vailed104619292_vailed
wailed104823592_wailed
abled86926833__abled
aided75828933__aided
aimed85626053__aimed
aired66032923__aired
airmailed1242903airmailed
aisled74516183__aisled
amassed10388623amassed
amazed18519303ama_zed
ambled115116353am_bled
anviled1138943anviled
ariled75620323_ariled
assailed945323assailed
awaited1146963awaited
axled135315813__axled
bailee84526013_bailee
bailer85425253_bailer
bailey115015673_bailey
baited95319243_baited
baled85436443_ba_led
balled94926893_balled
bawled124415693_bawled
begalled1236013begalled
beguiled1244443beguiled
bemired123410633bem_ired
bemixed19337053bem_ixed
besmiled1335493besmiled
bewailer1334863bewailer
boiled95020953_boiled
braided114013213braided
brailled1147193brailled
brained103816103brained
braised104014803braised
brawled133910123brawled
broiled103811423broiled
cabled114819873_cabled
called94126733_called
caviled1348723caviled
ceiled94114953_ceiled
chained133812693chained
chaired134211243chaired
claimed12298833claimed
coaled95022703coa_led
coiled95123933_coiled
compiled1537813compiled
craaled10339423craaled
cradled113410813cradled
crawled133710393crawled
deaired9411533deaired
defiled124013103defiled
demanded13348513demanded
demarked16187223demarked
demasted1238763demasted
demised113613683dem_ised
dentiled1039743dentiled
detailer9268673detailer
detained103111643detained
deviled124112183deviled
dialed84716453dia_led
dialled9510133dialled
doiled84817293_doiled
drained93713253drained
drawled12368343drawled
eagle64219483e_agle_
eagles73819163e_agles
eaglet73722583e_aglet
eared65139503e_a_red
earned74818333e_arned
eased65430403e_a_sed
easeled8159843easeled
eaved95924503e_a_ved
eddied9248323eddi_ed
edile64819493e_dile_
ediles74016973e_diles
edited83913673e_dited
elapsed1056103elapsed
elated74725823ela_ted
elided84814673e_lided
eloined8149813eloined
emaciated1446933emaciated
emailing113010043emailing
emanated1139163emanated
embalmed1544253embalmed
embanked17253883embanked
embarked17205213embarked
embarred13174793embarred
embattled1442563embattled
embayed1535443embayed
embed105014293em__bed
emblem1237573em_blem
embowed15236903embowed
embroiled1444593embroiled
embrued1235293embrued
emceed1136283em_ceed
emended11329603emended
emerged11158213emerged
emersed10138513emersed
emitted103010853emitted
emoted94614923em_oted
empale102611263empale_
empaler11288353empaler
empales112411433empales
empaneled1443433empaneled
empire1039313empire_
empires1139853empires
emptied1297393emptied
enable83318483enable_
enabler9299363enabler
enables92813123enables
enacted10310643enacted
enameled1136373enameled
endited93512913endited
engild8107613engil_d
engilded1143983engilded
engined9119893engined
engrailed1144323engrailed
enisled82510223enisled
ensile62616473ensile_
ensiles72714833ensiles
entailer877833entailer
enticed101411193enticed
entitled967503entitled
entoiled968283entoiled
envied1038833envi_ed
epaulet939513epaulet
equaled17166923equaled
equalled1834863equalled
erased74816753era_sed
ermined10410603ermined
espied9359773espi_ed
etoile6312263etoile_
etoiles7411293etoiles
evaded1137063eva_ded
eviler94811893e_viler
evited104013143e_vited
exacted1737303exacted
exalted1537393exalted
examined18135863examined
exampled2043353exampled
exapted1736073exapted
excided1836203excided
excised1736673excised
excited1737853excited
exhaled1835283exhaled
exile126117653e_xile_
exiler134712183e_xiler
exiles134816403e_xiles
exited144712523e_xited
expired1736403expired
fabled124216383_fabled
faired105915773_faired
female11310553fema_le_
females12310663fema_les
fenagled13184853fenagled
filed95331903__filed
foaled104515963foa_led
foiled104618403_foiled
frailer10319943frailer
gabled105518453_gabled
gained84617463_gained
gaited84416923_gaited
galled84622853_galled
gambled134112163gambled
gaoled84814493_gaoled
glaired9387743glaired
glaived12375973glaived
gnarled9287723gnarled
goaled85014353goa_led
grained93814273grained
guiled84315383_guiled
hailer94720343_hailer
haired105117173_haired
haled95335823_ha_led
hauled104415213_hauled
healed105121443hea_led
heiled104415613_heiled
imaged1097753ima_ged
imagined1254783imagined
imbibed1433713imbibed
immixed1933563immixed
impaired1335143impaired
impaled12288503impaled
impled113812503im_pled
implied1238613implied
jailer134316683_jailer
jemmied19294483jemmi_ed
kraaled12254983kraaled
ladled85013483_ladled
laired75216813_laired
lalled74218753_lalled
liaised837113liaised
maced108528693_ma_ced
mackled164111913_mackled
macle96127003_macle_
macles107023223_macles
maculed123510053_maculed
madded113513553_madded
maglev1237023_maglev
maid75537633_mai__d
maiden93512283_maiden
maihem1366213_maihem
mail65543433_mail__
mailers94420333_mailers
maill74420783_mail_l
maills84215283_maills
mailmen1137273_mailmen
mails76037773_mail_s
maimer104514593_maimer
maize164618553_maize_
maizes175115733_maizes
male66052293_ma_le_
males75049793_ma_les
malfed12369753_malfed
mallee84525593_mallee
mallei84414633_mallei
mallet84433053_mallet
malted94819853_malted
maned86634093_ma_ned
mangled113615253_mangled
manned94418643_manned
mantled104113393_mantled
maple95521143_maple_
maples104819423_maples
mapped134015883_mapped
marbled123212113_marbled
marked133921623_marked
marred95421043_marred
marted94425213_marted
mashed125325043_mashed
masked134316523_masked
massed94421323_massed
masted94025803_masted
mated85537783_ma_ted
matted94521413_matted
mauler84416713_mauler
mawed115824743_ma_wed
maxed155821193_ma_xed
mayed115522403_ma_yed
mazed175523873_ma_zed
mealie82519803mealie_
mealier93015903mealier
mealies92821933mealies
measle83513223measle_
measles92412753measles
meated94222403mea_ted
medaled113411603medaled
medalled1246883medalled
meddled123210023meddled
melled95023023_melled
merited10313853merited
metaled102913873metaled
metalled1148973metalled
mettled103510543mettled
mewled123710053_mewled
miauled1036663miauled
miked125020453_m_iked
mild75330843_m_il_d
milded104416153_m_ilded
mile66352563_m_ile_
miler75733063_m_iler
miles74645073_m_iles
milked134612573_m_ilked
milled94326173_milled
milted93919943_m_ilted
mimed105622733_m_imed
mined85333353_m_ined
mired85729223_m_ired
misled94719313_misled
mixed155717253_m_ixed
mobled113213183_mobled
moiler84017263_moiler
muled85824433_m_uled
mulled94721553_mulled
nailer64119363_nailer
naled65525053_na_led
oiled64429473__oiled
paiked135113433_paiked
pained95622853_pained
paired95017523_paired
paled85538723_pa_led
palled94625163_palled
parled94626273_parled
pealed95322803pea_led
pearled10411533pearled
pedaled113711873peda_led
pedalled1246903pedalled
penciled1337803penciled
periled10316293periled
petaled103614143peta_led
petalled1138683petalled
piled85232993__piled
plaided11409643plaided
plained103812233plained
plaited103713893plaited
praised104214813praised
prevailed1536043prevailed
raided85017703_raided
railer64524933_railer
rained75024603_rained
raised76120333_raised
rambled123913513rambled
reavailed1344003reavailed
rebaited11410543rebaited
reboiled11349393reboiled
recalled11310793recalled
recoiled113613213recoiled
redialed10310793redialed
refiled114318653refiled
regained102111243regained
regaled93615953rega_led
remail85017123remail__
remails94714563remail_s
remanded123011323remanded
remanned11319353remanned
remapped1534913remapped
remarked15209243remarked
remated103522473rema_ted
remised103516843rem_ised
remixed173510743rem_ixed
reoiled84316853reoiled
repaired1148953repaired
reraised9312353reraised
resiled84621983resiled
retailer82911573retailer
retained93016093retained
retiled84420513retiled
reviled114417923reviled
riled65833253__riled
roiled74320053_roiled
sailer63526103_sailer
sained75424243_sained
sampled123410783sampled
scaled94822443sca_led
sealed74328363sea_led
sepaled10510593sepa_led
sepalled1156903sepalled
shaled105023953sha_led
shauled1148793shauled
shawled1437773shawled
smacked163710993smacked
smaller93410333smaller
smarted105012613smarted
smashed133711223smashed
smelled103511853smelled
smile74823913sm_ile_
smiler83916683sm_iler
smiles84522293sm_iles
smiley114012303sm_iley
snarled83612353snarled
soiled73822473_soiled
spalled103113123spalled
speiled104412123speiled
spiled94621993_spiled
spoiled104811353spoiled
stabled103514953stabled
stained84215343stained
staled74728103sta_led
stalled83515683stalled
stapled103613693stapled
tabled94020043_tabled
tailer63823733_tailer
teazled17326833teazled
templed12278553tem_pled
tiled64832943__tiled
toenailed1043483toenailed
toiled74420323_toiled
traiked123310453traiked
trailer73015393trailer
trained84117203trained
trawled113411523trawled
umbeled12208193umbeled
umpired1235783umpired
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unhailed12219963unhailed
unnailed9229443unnailed
unoiled82415473unoiled
unpiled102312743unpiled
uppiled12216593uppiled
vealed103916323vea_led
veiled103714543_veiled
vialed105112593via_led
vialled1156843vialled
waifed134011033_waifed
wailer93720323_wailer
waired106015833_waired
waited103819773_waited
waived134511283_waived
waled94330993_wa_led
walled104021293_walled
wambled153610753wambled
wauled104713963_wauled
wawled133811703_wawled
weeviled1533143weeviled
whaled134612033wha_led
whiled134514133_whiled
wiled95231553__wiled
yawled13459983_yawled

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274468.79615237.3
3Display Results4464460.2331914.2
 (SQL Overall)1786914469.18519454.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.