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

440 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
earthed113992(None) 
earthen1039251earthen
airthed11328302airthed
arched125717322_arched
bathed125518742ba_thed
berthed13259122berthed
birthed13228592birthed
carted98631442cart_ed
darted84620922dart_ed
dartled9409852dartled
eared65139502ear__ed
earned74818332ear_ned
earth85023052earth__
earthier1137442earthier
earthly13387382earthly
earthmen1346392earthmen
earthpea1343422earthpea
earths95014592earth_s
earthset11410832earthset
earthy12399942earth_y
faithed1437162faithed
farted105121782fart_ed
farther1348342farther
girthed12266242girthed
hearted113314032heart_ed
inearthed1343622inearthed
lathed104718462la_thed
marched153813402marched
marted94425212mart_ed
narthex1734262narthex
parched154013692parched
parted94228682part_ed
partied103516552partied
searched14209252searched
tarted74923372tart_ed
unearthed1345572unearthed
warted104223232wart_ed
worthed1437872worthed
wrathed14298522wrathed
aahed917816443_a_ahed
ached119227833_a_ched
acted88521743_act_ed
aerated85322383aerated
aeried74221873aer_ied
aether94213673_aether
ahed89536253_a__hed
airshed11258533airshed
airted74214503airt_ed
althea938213_althea
anted66328243_ant_ed
anteed75616113_anteed
anthem113410343_anthem
anther93715063_anther
apartheid1543553apartheid
arced88224163_ar_ced
archer115016243_archer
arches114822043_arches
arcked136211943_arcked
argled85314553_argled
argued84311173_argued
ariled75620323_ariled
armed86324433_ar_med
artel56122743_art_el
artier63419733_artier
ashed97829773_a_shed
autoed7712823_autoed
bached145519893ba_ched
baited95319243bait_ed
barathea1345293barathea
barbed115121313bar_bed
barded105426423bar_ded
bared85144483bar__ed
barehead1446603barehead
barfed125416383bar_fed
barged105822643bar_ged
barked135027313bar_ked
barned95623583bar_ned
barred95725803bar_red
bartend1038753bartend
barter85525383bart_er
bartered113113033bartered
bashed126225703ba_shed
basted95227233bast_ed
batched154114243batched
bated85935533ba_t_ed
bathe105822883ba_the_
bather115322513ba_ther
bathes116524833ba_thes
batted95623653ba_tted
battled104213123battled
beached154516553bea_ched
bearded114212133bear_ded
berated104422133berat_ed
betrothed1544953betrothed
birched15349913birched
breathed14469643brea_thed
burthen1236363burthen
cached145419203ca_ched
canted94825783cant_ed
carded105424903car_ded
cared86050093car__ed
caried94528693car_ied
carked134024823car_ked
caroled103717693caroled
caromed123713623caromed
carped115923763car_ped
carried103717153carried
carte75940423cart_e_
cartel85022533cart_el
carter84932273cart_er
cartes86239473cart_es
cartoned111312833cartoned
carved124320853car_ved
cashed125124353ca_shed
castled104311513castled
cathead1338753ca_thead
catted95422473ca_tted
cerated103922473cerat_ed
charted135116853chart_ed
clothed134010283clothed
crashed134214213crashed
crated94827773crat_ed
dared75935013dar__ed
darked123919633dar_ked
darkled13378723darkled
darned85018483dar_ned
darter75320363dart_er
dartle73714833dartle_
dartles84014133dartles
dashed115920563da_shed
dated75530993da_t_ed
dauted84114933daut_ed
dawted11489683dawt_ed
dearth104212513dearth__
dearths11498843dearth_s
deashed123411303dea_shed
deathbed1543393dea_thbed
departed1238823depart_ed
derated93623503derat_ed
deratted1048403deratted
dirtied93210853dirtied
dratted9358593dratted
eagled82914043ea_gled
earache1239333earache_
earaches13411313earaches
earbud936283ear_bud
earlier72612743earlier
earner63617223ear_ner
earshot10410833earshot
earthiest1259113earthiest
earthily1445613earthily
earthing12310333earthing
earthlier1244303earthlier
earthman1346473earthman
earthnut1155663earthnut
earthpeas1443383earthpeas
earthsets1244123earthsets
earthward1643453earthward
eased65430403ea__sed
easeled8159863easeled
easter65027983east_er
eaten55323053ea_t_en
eater54639843ea_t_er
eath75735663ea_th__
eaved95924503ea__ved
ecarte84313503ecart_e_
ecartes94212563ecart_es
eched116919223e__ched
edited83913673edit_ed
either94517423e_ither
elated74725823elat_ed
eluted74915263elut_ed
emitted103010853emitted
emoted94614923emot_ed
emptied1297403emptied
enacted10310643enact_ed
enraged93511783enraged
enriched1435863enriched
enrobed10279263enrobed
epithet12312463epithet
erased74816763e_rased
eroded84313593e_roded
erred65915673e_r_red
etched123613703e_tched
ether84518773e__ther
everted112711853evert_ed
evited104013143evit_ed
exacted1737303exact_ed
exalted1537393exalt_ed
exanthem2043113exanthem
exapted1736073exapt_ed
exerted152210053exert_ed
exited144712523exit_ed
farced125216533far_ced
farded114518953far_ded
fared95842343far__ed
farmed125117653far_med
farthest1499863farthest
fartlek1434493fartlek
fashed136720253fa_shed
fasted105320953fast_ed
fated95632133fa_t_ed
fathead1437863fa_thead
father125116713fa_ther
fatted105419843fa_tted
feared106320433fear__ed
feasted11310843feast_ed
feather133613503fea_ther
frothed14288783frothed
further1337003further
gaited84416923gait_ed
garaged1039253garaged
garbed104815663gar_bed
garbled114512803garbled
gargled104210673gargled
garoted9710133garoted
garotted1066193garotted
garred85217413gar_red
garter74420513gart_er
gartered10319603gartered
garth94720223garth__
garths104111503garth_s
gashed116321973ga_shed
gasted84821583gast_ed
gated75329773ga_t_ed
gather104115863ga_ther
geared85317743gear__ed
gearhead1344443gear_head
girted83912873girt_ed
graphed1498473graphed
grated84523923grat_ed
hafted134713833haft_ed
halted105019603halt_ed
hanted104124313hant_ed
hardhead1645883hardhead
hared95742183har__ed
harked145422553har_ked
harmed125218833har_med
harped124418403har_ped
harried113815543harried
harshen1339283harshen
harsher13310363harsher
hashed136021943ha_shed
hasted105125283hast_ed
hatched163414463hatched
hated95734023ha_t_ed
hatred104814333ha_tred
hatted104921513ha_tted
hearsed113811423hear_sed
hearten102411763heart_en
heartened1347083heartened
hearth125315213hearth__
hearths135311073hearth_s
heartier1139103heartier
hearties11315423hearties
heated104525593hea_t_ed
heathen133410893hea_then
heather133914853hea_ther
hurtled11339593hurtled
inarched1486113inarched
jarhead1835173jar_head
jarred144613253jar_red
kirtled12287033kirtled
kithed144613013_kithed
kythed17407313_kythed
larchen12479633larchen
larches124416453larches
larded84319093lar_ded
larked114519473lar_ked
lashed105625213la_shed
lasted74323603last_ed
latched133914073latched
lated65240673la_t_ed
lathe85626723la_the_
lather95124363la_ther
lathes95127503la_thes
laughed1235893laughed
leached133715043lea_ched
learned8329303lear_ned
leashed113211163lea_shed
leather103815783lea_ther
loathed11419443loathed
lurched13358033lurched
malted94819863malt_ed
mantled104113393mantled
marbled123212113marbled
marchen143312073marchen
marcher143912973marcher
marches143921173marches
marked133921623mar_ked
marled95523163mar_led
marred95421043mar_red
married104715303married
marshes123615373marshes
marten84518263mart_en
martlet93419153martlet
martyred1434293martyred
mashed125325043ma_shed
masted94025803mast_ed
masthead1435883masthead
matched153513963matched
mated85537783ma_t_ed
matted94521413ma_tted
meated94222403mea_t_ed
meathead1436793mea_thead
morphed1537133morphed
mouthed133811043mouthed
murther1237953murther
narked114116743nar_ked
neared75119813near__ed
neatherd12107193nea_therd
norther1039733norther
oared65030653oar__ed
orated74221503orat_ed
panted95024823pant_ed
panther12611443panther
paraded114014263paraded
parches143720003parches
pared86946763par__ed
parged104922043par_ged
parked134425143par_ked
parled94626293par_led
paroled104217633paroled
parred95024073par_red
parried103615723parried
parsed96323893par_sed
partier93520713partier
parties93230873parties
partlet92720363partlet
partner92811393partner
partyer12337873partyer
pashed125923143pa_shed
pasted94426903past_ed
patched153514623patched
pated85237843pa_t_ed
patted94724683pa_tted
peached154315883pea_ched
pearled10411553pear_led
pearter9412743peart_er
perched154713243perched
pithed124615613_pithed
ported94223243port_ed
prated94924923prat_ed
rafted104714703raft_ed
ralphed1334363ralphed
ranched133113603ranched
ranted74324703rant_ed
rared65738323rar__ed
rated65441383ra_t_ed
rathe85821923ra_the_
rather94319743ra_ther
ratted74923343ra_tted
rattled84012953rattled
reached134619083rea_ched
reacted103015713react_ed
reared75930013rear__ed
reargued1035573reargued
rearmed103912823rear_med
saithe94713913saithe_
salted74121203salt_ed
sashed105622943sa_shed
sated66238533sa_t_ed
sauted74119603saut_ed
sauteed8349613sauteed
scarphed1635443scarphed
scarted104816123scart_ed
scathed134012643scathed
scythed16385303scythed
searcher13209103searcher
searches132112903searches
seared75232843sear__ed
seated75131063sea_t_ed
seethed113410193seethed
sheathed1547223shea_thed
smarted105012613smart_ed
soothed113712743soothed
sorted74523713sort_ed
sortied83314103sortied
southed114313993southed
spathed134013183spathed
starched14199313starched
started84217323start_ed
startled9208563startled
swathed144611933swathed
tared69340053tar__ed
tarred74720283tar_red
tarried83914133tarried
tarter64023563tart_er
tartier74123263tartier
tartlet72218483tartlet
tarweed1137343tarweed
tasted74123973tast_ed
tatted74920533ta_tted
tattled84311483tattled
tauted75317113taut_ed
teared75722153tear__ed
teated74924023tea_t_ed
teethed11318623teethed
tithed104115593_tithed
toothed113310243toothed
torched133511363torched
trashed113514703trashed
trothed114010973trothed
turtled8309683turtled
tythed13457503_tythed
unarched14128553unarched
varied104817863var_ied
varved134110603var_ved
vatted104214733va_tted
wafted134012143waft_ed
waited103819773wait_ed
waltzed2033493waltzed
wanted104319723want_ed
warbled133212163warbled
warded115021043war_ded
wared96339873war__ed
warhead1436603war_head
warked144421213war_ked
warmed124516893war_med
warned104018913war_ned
warped124816413war_ped
warred104019853war_red
warsled112910443warsled
warstled12286123warstled
warthog1444543warthog
wartier103413913wartier
washed135521503wa_shed
wasted104423023wast_ed
watched163012823watched
wattled113610503wattled
wearied112911823wear_ied
weather133513223wea_ther
withed134416233_withed
wreathed15257463wrea_thed
writhed14389623writhed
yachted1634853yachted
yarded114714023yar_ded
yarned105514023yar_ned
yearned11327373year_ned
yeasted1138503yeast_ed

Search took 8 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.390458182.1
2DLD Change Limit1340274406.51620568.9
3Display Results4404400.1562820.5
 (SQL Overall)1786914407.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.