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

297 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
dharna105526(None) 
dharma1276101dharma
dharnas1155371dharnas
dhurna1043561dhurna
amarna839792amarna
charka154011702charka
darn56434622d_arn_
darns66927892d_arns
dharmas1356512dharmas
dhurnas1153442dhurnas
sharia93116732sharia
sharn84823702sharn_
sharns95516982sharns
sharny124711832sharny
varna84516172_varna
ana39559833__a_na
anna45529013__anna
area45843393__area
arena55323813__arena
aria46245423__aria
asana5315483asa_na
barca91319433_barca
barn66444643_barn_
barns76335143_barns
barny105821733_barny
bhakta1533653bhakta
bhang115512923bha_ng
bharal1138893bharal
bwana10310243bwa_na
canna75919333_canna
carina84325323_carina
carn66245433_carn_
carnal83919203_carnal
carns75937563_carns
carny105822923_carny
chacma1537903chacma
chaeta11310683chaeta
chain105723673chain_
chaine115119223chaine
chains114819703chains
chakra15437533chakra
challa114014193challa
chang115418563cha_ng
chant105932693cha_nt
char95132153char__
charas114223613charas
chard116124743char_d
chards125119733chards
chare105231983char_e
chared125423693chared
chares115631803chares
charge125114213charge
charing133721323charing
chark144222713char_k
charkas164810963charkas
charkha19405153charkha
charks155219703charks
charm126124663char_m
charms135218843charms
charnel124010053charnel
charpai1436633charpai
charr104821783char_r
charro114212953charro
charrs115219193charrs
charry145012113charry
chars105936643char_s
chart105038283char_t
charts115823093charts
chary135023133char_y
chaunt11613493chaunt
chazan20269133chazan
china105022483ch_ina
choana1138443choana
chorea115216083chorea
churn105113103churn_
churns114910233churns
czarina1845953czarina
dacha114812573d_acha
dada66422443d_a_da
dagga839543d_agga
dahlia1035773dahlia
daman84821163d_aman
damn75724323d_amn_
damns84916923d_amns
dan46859673d_a_n_
dang65131543d_a_ng
dank95828243d_a_nk
dans56748153d_a_ns
darb76033533d_ar_b
darbar959953d_arbar
darbs85323263d_arbs
dare55848863d_ar_e
dared75935013d_ared
darer65230793d_arer
dares66146703d_ares
daric85623113d_aric
daring84928683d_aring
dark95133213d_ar_k
darks106727873d_arks
darky136018833d_arky
darned85018483d_arned
darnel74312183d_arnel
darner74017303d_arner
dart55857873d_ar_t
darts67635733d_arts
data56026653d_a_ta
daunt65929083d_aunt
dawn85624203d_awn_
dawns95916593d_awns
dean56039483dea_n_
deans66131393dea_ns
dear55343603dear__
dearer74822803dearer
dearie73319813dearie
dearly104615323dearly
dears65736883dear_s
dearth104212513dearth
deary95826843dear_y
dehorn10439653dehorn_
dehorns11428363dehorns
derma84918513d_erma
dhak125512033dha__k
dhaks13479703dha_ks
dhal86719283dha__l
dhals95415443dha_ls
dharmic1535013dharmic
dhoora1035653dhoora
dhourra1152023dhourra
diary95016973diar_y
diurnal844883diurnal
dobra85013103dobr_a
dona55529633d__ona
donna66215033d_onna
dorsa64617283d_orsa
doura66518663dour_a
dracena1034923dracena
drain65222893drain_
drains73719403drains
drama85117413dra_ma
drank104816203dra_nk
drawn95614243drawn_
duenna734593duenna
dura55232113d_ur_a
durn56127633d_urn_
durns64819873d_urns
durra65315793d_urra
dwarf126015243dwar_f
dwarfs13436273dwarfs
earn46737553_earn_
earns55927563_earns
faena85014203_faena
farina94618233_farina
fauna84816513_fauna
fraena938063fraena
garda7316763_garda
garni6315703_garni
gharial1137343gharial
gharri10386163gharri
gharry13546273gharry
goanna736653goanna
grana65722093gra_na
guarana886303guarana
haen76229453_haen_
haha107821063_ha_ha
haika125313793_haika
haint85436323_haint
halma108219253_halma
halva115414433_halva
hamza19139773_hamza
hand86833713_ha_nd
hang85535553_ha_ng
hank115134143_ha_nk
hansa85416783_hansa
hant75461593_ha_nt
hard85443503_har_d
hards96435653_hards
hardy125622063_hardy
hare76255733_har_e
hared95742183_hared
harem104924453_harem
hares86255543_hares
hariana10310243_hariana
haring104233003_haring
hark115237393_har_k
harks126333433_harks
harl75740003_har_l
harls85634503_harls
harm95637793_har_m
harms106829013_harms
harp96134293_har_p
harps105926873_harps
harpy136418213_harpy
harry115322953_harry
harsh116418053_harsh
hart76865773_har_t
hartal9415473_hartal
harts88441593_harts
haunt85229133_haunt
hazan173813613_hazan
henna84414043_henna
herma105318883_herma
hern76134893_hern_
hernia9312293_hernia
herns84825583_herns
hora76136563_hor_a
horn76735613_horn_
horns86125333_horns
horny115619623_horny
hyaena1235363hyaena
hyena11810253_hyena
jarina134014063_jarina
jnana12159043jna_na
kahuna1394103kahuna
kana85928533_ka_na
karma113415003_karma
karn86129413_karn_
karns96624143_karns
khan115819143kha_n_
khans124615173kha_ns
larva8312483_larva
learn55322663learn_
learns65513743learns
learnt64019253learnt
liana53915893lia_na
mana65341963_ma_na
manna75522543_manna
mara67444573_mar_a
maria75032883_maria
marina84623413_marina
marka114620793_marka
nana46632903_na_na
ocarina948033ocarina
para65242173_par_a
parka115120883_parka
pharos11312063pharos
pharynx2241813pharynx
pirana8713263pirana
prajna1535073prajna
purana8712933purana
ruana5312423rua_na
saran53730303_saran
sauna54117553_sauna
shairn9269063shairn_
shairns10276783shairns
shaman113314283shaman
shank125422193sha_nk
shanny124110093shanny
shard96125963shar_d
shards104319173shards
share86437083shar_e
shared105829063shared
sharer95025483sharer
shares95236413shares
shariah132210533shariah
sharias102516003sharias
sharif122917123sharif
sharing113723243sharing
shark126225023shar_k
sharks135019723sharks
sharp104922533shar_p
sharps115516083sharps
sharpy145211033sharpy
shawn116417613shawn_
sherpa1138093sherpa
shoran94016043shoran
shorn85722183shorn_
shrank13359123shrank
sterna63712763sterna
tarn46842723_tarn_
tarnal63716503_tarnal
tarns56433953_tarns
than76128773tha_n_
thane86122533tha_ne
thank125817803tha_nk
tharm105916643thar_m
tharms115712243tharms
thoria93012893thoria
thorn85318703thorn_
thorns95314103thorns
thorny12509843thorny
tiara5315913tiar_a
tsarina736653tsarina
tzarina1635053tzarina
vara75530883_var_a
varia85824203_varia
varnas94212823_varnas
warn75239323_warn_
warns87231003_warns
whang124813383wha_ng
wharf14315823whar_f
wharfs1546373wharfs
wharve15456203wharve
yarn75230043_yarn_
yarns85621793_yarns
yearn86316433yearn_
yearns9509543yearns
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.373479064.3
2DLD Change Limit1127162974.97022679.3
3Display Results2972970.0933193.5
 (SQL Overall)1786912975.43632871.8
 
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.