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
dharma127610(None) 
dharmas1356501dharmas
dharna1055261dharna
chacma1537902chacma
charka154011702charka
charm126124662charm_
charms135218832charms
derma84918512d_erma
dharmic1535012dharmic
dharnas1155372dharnas
dhurna1043562dhurna
drama85117412dra_ma
halma108219252_halma
harm95637792_harm_
harms106829012_harms
herma105318882_herma
karma113415002_karma
sharia93116722sharia
tharm105916642tharm_
tharms115712242tharms
agama85815573aga_ma
agma77623263__agma
alarm76621423alarm_
alarms85913053alarms
alma66333023__alma
ama510853303__a_ma
amarna839793amarna
area45843393__area
aria46245423__aria
arm58449623__arm_
arms66137493__arms
army96624183__army
aroma71220143__aroma
asrama839193asrama
atma68121773__atma
barca91319433_barca
barm86739603_barm_
barman103519703_barman
barms96128463_barms
barmy125218763_barmy
bhakta1533653bhakta
bharal1138893bharal
brahma1336193brahma
carman103920743_carman
chacmas1637993chacmas
chaeta11310683chaeta
chairman15106373chairman
chakra15437533chakra
challa114014193challa
cham115532313cha_m_
chammy18488953chammy
champ145017963cha_mp
chams126028503cha_ms
chapman1637893chapman
char95132153char__
charas114223593charas
chard116124743char_d
chards125119723chards
chare105231983char_e
chared125423693chared
chares115631803chares
charge125114213charge
charisma1576353charisma
chark144222713char_k
charkas164810953charkas
charkha19405153charkha
charks155219703charks
charmed154714243charmed
charmer144913663charmer
charpai1436623charpai
charr104821783char_r
charro114212953charro
charrs115219183charrs
charry145012113charry
chars105936633char_s
chart105038283char_t
charts115823093charts
chary135023133char_y
chasm125518793chasm_
chasmal14158213chasmal
chasms135513143chasms
chasmy16468543chasmy
chiasma14366983chiasma
chirm125317063chirm_
chirms135113983chirms
chorea115216083chorea
chroma132912473chroma
dacha114812573d_acha
dada66422443d_a_da
dagga839543d_agga
dahlia1035773dahlia
dam67457043d_a_m_
daman84821163d_a_man
damar84117733d_a_mar
dame77140313d_a_me
dammar11438903d_ammar
damn75724323d_a_mn
damp96228843d_a_mp
dams77444373d_a_ms
darb76033533d_ar_b
darbar959953d_arbar
darbs85323263d_arbs
dare55848863d_ar_e
dared75935013d_ared
darer65230793d_arer
dares66146703d_ares
daric85623113d_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_
dermal93614343d_ermal
dermas94116813d_ermas
derms85022893d_erms
dhak125512033dha__k
dhaks13479703dha_ks
dhal86719283dha__l
dhals95415443dha_ls
dhoora1035653dhoora
dhourra1152023dhourra
dhurnas1153443dhurnas
diagram1147363diagram
diary95016973diar_y
digamma1343093digamma
diorama1046523diorama
diram84419473diram_
dirams94413703dirams
disarm9310473disarm_
disarms1039043disarms
dobra85013103dobr_a
dogma96112463d_ogma
dolma86214173d_olma
doorman1037063doorman
doormat1059073doormat
dorm76834623d_orm_
dorms85723833d_orms
dormy115817463d_ormy
dorsa64617283d_orsa
douma85817703d_ouma
doura66518663dour_a
drachma1544303drachma
dram75832003dra_m_
dramas95814653dra_mas
drams86025833dra_ms
drayman1335433drayman
duma75524453d__uma
dura55232113d_ur_a
durra65315793d_urra
dwarf126015243dwar_f
dwarfs13436273dwarfs
farm95934533_farm_
farms106324953_farms
gama77035513_ga_ma
gamma106116103_gamma
garda7316763_garda
gharial1137343gharial
gharri10386163gharri
gharry13546273gharry
grama85620283gra_ma
gramma11499803gramma
haem95730983_haem_
haemal113811643_haemal
haems105517013_haems
haha107821063_ha_ha
haika125313793_haika
halm95834973_halm_
halmas117017893_halmas
halms105225213_halms
halva115414433_halva
ham86363283_ha_m_
hamal104623103_ha_mal
hame97043133_ha_me
hammal134512063_hammal
hammam12419333_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
harmed125218833_harmed
harmer114719553_harmer
harmin113117393_harmin
harp96134283_har_p
harps105926863_harps
harpy136418203_harpy
harry115322953_harry
harsh116418053_harsh
hart76865773_har_t
hartal9415473_hartal
harts88441593_harts
hazmat20312263_hazmat
herm95636153_herm_
hermae115314473_hermae
hermai118912843_hermai
herms105626433_herms
hora76136553_hor_a
ihram10310183ihram_
ihrams1137173ihrams
inarm7314423inarm_
inarms8410093inarms
karmas123013733_karmas
korma115913073_korma
lama66635293_la_ma
larva8312483_larva
llama799893lla_ma
magma104513573_magma
mahatma1443783mahatma
mama86231583_ma_ma
mamma86317913_mamma
mara67444563_mar_a
maria75032883_maria
marka114620793_marka
miasma1097563miasma
para65242173_par_a
parka115120883_parka
pharmacy2043243pharmacy
pharos11312063pharos
plasma103810913plasma
rearm75923563rearm_
rearms85114653rearms
sham96436353sha_m_
shaman113314273sha_man
shamas113717933sha_mas
shame105726703sha_me
shammas14358713shammas
shammy16388503shammy
shams105829413sha_ms
shard96125963shar_d
shards104319173shards
share86437083shar_e
shared105829063shared
sharer95025483sharer
shares95236413shares
shariah132210533shariah
sharias102516003sharias
sharif122917113sharif
shark126225023shar_k
sharks135019723sharks
sharn84823703shar_n
sharns95516983sharns
sharny124711833sharny
sharp104922533shar_p
sharps115516083sharps
sharpy145211033sharpy
shawm135316143shawm_
shawms14579563shawms
shazam2046603shazam
sherpa1138093sherpa
smarm95517603smarm_
smarms105712533smarms
smarmy13629353smarmy
swarm106218833swarm_
swarms116112163swarms
tarama8412723_tarama
tarmac10310333_tarmac
thairm1156963thairm_
thairms1244453thairms
therm106018023therm_
thermae125310493thermae
thermal125010963thermal
therme115814993therme
therms115914873therms
thiram1139943thiram
thoria93012883thoria
tiara5315903tiar_a
trauma838803trauma
ulama7711473ula_ma
unarm7314453unarm_
unarms839243unarms
vara75530883_var_a
varia85824203_varia
varna84516173_varna
warm95935673_warm_
warms107726853_warms
wham125321693wha_m_
whammo16405193whammo
whammy19375293whammy
whamo135511263wha_mo
whams135515643wha_ms
wharf14315823whar_f
wharfs1546373wharfs
wharve15456203wharve
zoaria1548373zoaria

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 Filter1786911127160.280638182.1
2DLD Change Limit1127163078.20313740.8
3Display Results3073070.0933301.1
 (SQL Overall)1786913078.57620836.2
 
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.