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

257 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
echards133796(None) 
chards125119731_chards
echard1249221echard_
becharms1745342becharms
cards85137932_c_ards
chads116122232_cha_ds
charas114223612_charas
chard116124742_chard_
chares115631802_chares
charks155219702_charks
charms135218842_charms
charrs115219192_charrs
chars105936642_char_s
charts115823092_charts
chords125214632_chords
eschars1237182eschar_s
eucharis1347442eucharis
hards96435652__hards
orchards1445912orchards
pochards1646852pochards
recharts1337662recharts
shards104319172_shards
acarids105312243ac_arids
acarus8312193ac_arus
accords1247243accords
awards107113453_awards
bards87139643__bards
bayards13379683bayards
beards94116673_beards
bechalks1944793bechalks
becharm1636843bechar_m
becowards1743843becowards
bedwards1596393bedwards
beeyards1444593beeyards
boards94616933_boards
boyards13399323boyards
briards10398553briards
cads76144523_c_a_ds
caids85226423_c_aids
cairds96411513_cairds
canards10311203canards
carbs96031463_c_arbs
card710245873_c_ard_
cares77369183_c_ares
carks115534213_c_arks
carls77037423_c_arls
carns75937563_c_arns
carps96932253_c_arps
carrs75730853_c_arrs
cars67364763_c_ar_s
carts78946293_c_arts
cedars93312833cedar_s
chad105525503_cha_d_
chadri1238143_chadri
chafes145017913_chafes
chaffs17459613_chaffs
chains114819703_chains
chairs114916183_chairs
chais107530313_cha_is
chakras16428503_chakras
chalks155412143_chalks
champs154915683_champs
chams126028503_cha_ms
changs125215373_changs
chants115020393_chants
chaos105622863_cha_os
chapes135421873_chapes
chaps125326063_cha_ps
char95132153_char__
charade13129913_charade
charades141310853_charades
chare105231983_char_e
chared125423693_chared
charge125114213_charge
charges134615983_charges
charism14712203_charism
chark144222713_char_k
charka154011703_charka
charkas164810963_charkas
charm126124663_char_m
charr104821783_char_r
charro114212953_charro
charros124312143_charros
charry145012113_charry
chart105038283_char_t
chary135023133_char_y
chases115128233_chases
chasms135513143_chasms
chats105730093_cha_ts
chaws135022463_cha_ws
chays135319743_cha_ys
cherts115617233_cherts
chirks155414843_chirks
chirms135113983_chirms
chiros114617773_chiros
chirps135414003_chirps
chirrs114514983_chirrs
chirus114615693_chirus
chord115917263_chord_
chores114828023_chores
chorus115014773_chorus
churls115411073_churls
churns114910233_churns
churrs115111513_churrs
clads85722733_cla_ds
claros84015113_claros
clochards1743823clochards
cords86030623_c_ords
cowards1339613cowards
curds85725613_c_urds
czardas1934673_czardas
czars164812913_czar_s
debeards1235503debeards
decares102818533dec_ares
deciares11510633deciares
deckhands2043083deckhands
declares11611313declares
diehards1346213diehards
dotards937253dotards
earls56127513e__arls
earns55927563e__arns
ears46356593e__ar_s
ecarte84313503ec_arte
ecartes94212563ec_artes
eched116919223ech_ed_
eches106322163ech__es
echinus1236203echinus
echoed125211153echoed_
echoers12459693echoers
echoes114715523ech_oes
echos105216463ech__os
eclairs935963eclairs
eclats8313033ecla_ts
ecrus75113863ec__rus
ectases92911673ectases
ectasis9249613ectasis
egads74610923e_ga_ds
eggars8398973eggar_s
elands74914773e_lands
embarks15337353embarks
embars103812883embar_s
enchains1348523enchains
enchants1347833enchants
enchases13310273enchases
engirds995053engirds
enhalos1087533enhalos
ephahs1435503epha_hs
ephas10311543epha__s
ephods1238363eph_ods
ephors11311403ephor_s
errands847603errands
escarps11397373escarps
escars83913133escar_s
eschar1136533eschar__
eskars10357593eskar_s
etchants1346023etchants
etchers123411293etcher_s
ethanes103713513ethanes
ethers94518413ether_s
euchres1288663euch_res
exhales1737143exhales
exhorts1746313exhorts
expands17195733expands
fards96629843__fards
guards84611573_guards
hands95327383__hands
hard85443503__hard_
hardy125622063__hardy
hares86255543__hares
harks126333433__harks
harls85634503__harls
harms106829013__harms
harps105926873__harps
harts88441593__harts
hazards2037463hazards
hectares1338853hectares
herds96424683__herds
hoards104912623_hoards
holards1148433holards
hurds95219073__hurds
ichors11310423ichor_s
innards837153innards
inwards1138343inwards
izzards16143963izzards
jehads1735833jeha_ds
jeopards1843683jeopards
jihads1734483jiha_ds
keycards1843063keycards
lahars94013163lahar_s
lards65331863__lards
lechers123313963lecher_s
leewards1244983leewards
leopards1144753leopards
leotards945303leotards
liards75212613_liards
lizards17427613lizards
mazards1937703mazards
nards65928463__nards
nectars938463nectar_s
ochers113915303ocher_s
ochres113510833och_res
octads987333octa_ds
onwards1137173onwards
orchard1346933orchard_
pards85634333__pards
pechans14810503pecha_ns
petards104311153petards
pharos11312063_pharos
pilchards1743923pilchards
pochard1537363pochard_
reboards1138773reboards
recharge1476613recharge
recharges1586953recharges
rechart12314333rechar_t
reclads1049993recla_ds
records105213923rec_ords
regards94112563regards
retards85015003retards
rewards114813993rewards
reynards1244303reynards
ritards8439943ritards
sards64736183__sards
scads85419963sc_a_ds
scalds94813693sc_alds
scares85033003sc_ares
scarfs114714683sc_arfs
scarps104718603sc_arps
scars75433533sc_ar_s
scarts85321493sc_arts
schavs1436493scha_vs
schorls1248353schorls
schrods1337433schrods
seawards1237203seawards
secpars1138413secpar_s
shads95124483_sha_ds
shairds11216263_shairds
shard96125963_shard_
shares95236413_shares
sharks135019723_sharks
sharns95516983_sharns
sharps115516083_sharps
sherds105614723_sherds
swards105415133_swards
tabards10310383tabards
tharms115712243_tharms
thirds10438603_thirds
towards1138783towards
unhands1137773unhands
uphoards1443763uphoards
upwards13135963upwards
vawards14457573vawards
visards11328153visards
vizards20377263vizards
wards97734403__wards
wharfs1546373_wharfs
wizards20326403wizards
yards95324613__yards

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.390458182.1
2DLD Change Limit1340272576.40620922.1
3Display Results2572570.0803212.5
 (SQL Overall)1786912576.87625987.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.