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

307 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
dharma127611(None) 
dharmas1356521dharmas
dharna1055261dharna
chacma1537902chacma
charka154011702charka
charm126124662charm_
charms135218842charms
derma84918522d_erma
dharmic1535022dharmic
dharnas1155372dharnas
dhurna1043562dhurna
drama85117432dra_ma
halma108219262_halma
harm95637802_harm_
harms106829022_harms
herma105318892_herma
karma113415032_karma
sharia93116732sharia
tharm105916642tharm_
tharms115712242tharms
agama85815583aga_ma
agma77623273__agma
alarm76621423alarm_
alarms85913053alarms
alma66333033__alma
ama510853313__a_ma
amarna839793amarna
area45843403__area
aria46245433__aria
arm58449633__arm_
arms66137503__arms
army96624193__army
aroma71220153__aroma
asrama839193asrama
atma68121783__atma
barca91319443_barca
barm86739613_barm_
barman103519723_barman
barms96128473_barms
barmy125218773_barmy
bhakta1533653bhakta
bharal1138893bharal
brahma1336193brahma
carman103920763_carman
chacmas1638003chacmas
chaeta11310683chaeta
chairman15106383chairman
chakra15437533chakra
challa114014193challa
cham115532313cha_m_
chammy18488953chammy
champ145017963cha_mp
chams126028503cha_ms
chapman1637893chapman
char95132153char__
charas114223613charas
chard116124743char_d
chards125119733chards
chare105231983char_e
chared125423693chared
chares115631803chares
charge125114213charge
charisma1576363charisma
chark144222713char_k
charkas164810963charkas
charkha19405153charkha
charks155219703charks
charmed154714253charmed
charmer144913663charmer
charpai1436633charpai
charr104821783char_r
charro114212963charro
charrs115219193charrs
charry145012113charry
chars105936643char_s
chart105038283char_t
charts115823093charts
chary135023133char_y
chasm125518793chasm_
chasmal14158213chasmal
chasms135513143chasms
chasmy16468543chasmy
chiasma14366993chiasma
chirm125317063chirm_
chirms135113983chirms
chorea115216093chorea
chroma132912473chroma
dacha114812573d_acha
dada66422453d_a_da
dagga839543d_agga
dahlia1035773dahlia
dam67457043d_a_m_
daman84821173d_a_man
damar84117753d_a_mar
dame77140313d_a_me
dammar11438913d_ammar
damn75724323d_a_mn
damp96228843d_a_mp
dams77444373d_a_ms
darb76033533d_ar_b
darbar959963d_arbar
darbs85323263d_arbs
dare55848863d_ar_e
dared75935013d_ared
darer65230793d_arer
dares66146703d_ares
daric85623123d_aric
dark95133213d_ar_k
darks106727873d_arks
darky136018833d_arky
darn56434623d_ar_n
darns66927893d_arns
dart55857873d_ar_t
darts67635733d_arts
data56026653d_a_ta
deadman11238423deadman
dear55343603dear__
dearer74822803dearer
dearie73319813dearie
dearly104615323dearly
dears65736883dear_s
dearth104212513dearth
deary95826843dear_y
derm76031893d_erm_
dermal93614353d_ermal
dermas94116823d_ermas
derms85022893d_erms
dhak125512033dha__k
dhaks13479703dha_ks
dhal86719283dha__l
dhals95415443dha_ls
dhoora1035653dhoora
dhourra1152023dhourra
dhurnas1153443dhurnas
diagram1147363diagram
diary95016973diar_y
digamma1343103digamma
diorama1046533diorama
diram84419473diram_
dirams94413703dirams
disarm9310473disarm_
disarms1039043disarms
dobra85013103dobr_a
dogma96112463d_ogma
dolma86214173d_olma
doorman1037063doorman
doormat1059073doormat
dorm76834633d_orm_
dorms85723843d_orms
dormy115817473d_ormy
dorsa64617283d_orsa
douma85817703d_ouma
doura66518663dour_a
drachma1544303drachma
dram75832003dra_m_
dramas95814673dra_mas
drams86025833dra_ms
drayman1335433drayman
duma75524453d__uma
dura55232113d_ur_a
durra65315793d_urra
dwarf126015243dwar_f
dwarfs13436273dwarfs
farm95934543_farm_
farms106324963_farms
gama77035533_ga_ma
gamma106116113_gamma
garda7316773_garda
gharial1137343gharial
gharri10386163gharri
gharry13546273gharry
grama85620293gra_ma
gramma11499803gramma
haem95730983_haem_
haemal113811653_haemal
haems105517013_haems
haha107821063_ha_ha
haika125313793_haika
halm95834973_halm_
halmas117017903_halmas
halms105225213_halms
halva115414433_halva
ham86363283_ha_m_
hamal104623123_ha_mal
hame97043133_ha_me
hammal134512073_hammal
hammam12419343_hammam
hammy155113433_hammy
hams96446133_ha_ms
hamza19139773_hamza
hansa85416783_hansa
hard85443503_har_d
hards96435653_hards
hardy125622063_hardy
hare76255733_har_e
hared95742183_hared
harem104924453_harem
harems115513823_harems
hares86255543_hares
hark115237393_har_k
harks126333433_harks
harl75740003_har_l
harls85634503_harls
harmed125218843_harmed
harmer114719563_harmer
harmin113117403_harmin
harp96134293_har_p
harps105926873_harps
harpy136418213_harpy
harry115322953_harry
harsh116418053_harsh
hart76865773_har_t
hartal9415483_hartal
harts88441593_harts
hazmat20312273_hazmat
herm95636153_herm_
hermae115314483_hermae
hermai118912873_hermai
herms105626433_herms
hora76136563_hor_a
ihram10310183ihram_
ihrams1137173ihrams
inarm7314423inarm_
inarms8410093inarms
karmas123013763_karmas
korma115913093_korma
lama66635303_la_ma
larva8312493_larva
llama799893lla_ma
magma104513583_magma
mahatma1443783mahatma
mama86231603_ma_ma
mamma86317923_mamma
mara67444583_mar_a
maria75032893_maria
marka114620803_marka
miasma1097563miasma
para65242183_par_a
parka115120893_parka
pharmacy2043243pharmacy
pharos11312063pharos
plasma103810913plasma
rearm75923573rearm_
rearms85114653rearms
sham96436363sha_m_
shaman113314283sha_man
shamas113717943sha_mas
shame105726703sha_me
shammas14358723shammas
shammy16388503shammy
shams105829413sha_ms
shard96125963shar_d
shards104319173shards
share86437083shar_e
shared105829063shared
sharer95025483sharer
shares95236413shares
shariah132210533shariah
sharias102516003sharias
sharif122917123sharif
shark126225023shar_k
sharks135019723sharks
sharn84823703shar_n
sharns95516983sharns
sharny124711833sharny
sharp104922533shar_p
sharps115516083sharps
sharpy145211033sharpy
shawm135316153shawm_
shawms14579563shawms
shazam2046623shazam
sherpa1138093sherpa
smarm95517603smarm_
smarms105712533smarms
smarmy13629353smarmy
swarm106218843swarm_
swarms116112173swarms
tarama8412743_tarama
tarmac10310353_tarmac
thairm1156963thairm_
thairms1244453thairms
therm106018023therm_
thermae125310503thermae
thermal125010973thermal
therme115814993therme
therms115914873therms
thiram1139963thiram
thoria93012893thoria
tiara5315913tiar_a
trauma838803trauma
ulama7711473ula_ma
unarm7314453unarm_
unarms839243unarms
vara75530893_var_a
varia85824213_varia
varna84516183_varna
warm95935683_warm_
warms107726863_warms
wham125321693wha_m_
whammo16405193whammo
whammy19375293whammy
whamo135511263wha_mo
whams135515643wha_ms
wharf14315823whar_f
wharfs1546373wharfs
wharve15456213wharve
zoaria1548383zoaria

Search took 6 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.390458182.1
2DLD Change Limit1127163074.69024033.3
3Display Results3073070.1062896.2
 (SQL Overall)1786913075.18634456.4
 
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.