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

223 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
dharnas115537(None) 
dharmas1356511dharmas
dharna1055261dharna_
dhurnas1153441dhurnas
charas114223612char_as
charkas164810962charkas
darns66927892d_arn_s
dharma1276102dharma_
dhurna1043562dhurna_
sharias102516002sharias
sharns95516982sharn_s
varnas94212822_varnas
amarna839793amarna_
anas46649863__a_nas
annas55824883__annas
areas55935773__areas
arenas65021993__arenas
arias55438023__arias
arras55626133__arras
asanas6514113asa_nas
barcas101016603_barcas
barns76335143_barn_s
bhaktas1633643bhaktas
bhangs12449663bha_ngs
bharal1138893bhar_al
bharals1236733bharals
bwanas1157443bwa_nas
cannas84518403_cannas
carinas93622413_carinas
carnal83919213_carnal
carns75937563_carn_s
chacmas1638003chacmas
chaines124518733chaines
chains114819703chain_s
chakras16428503chakras
challas124414123challas
changs125215373cha_ngs
chants115020393cha_nts
chards125119733char_ds
chares115631803char_es
charges134615983charges
charka154011703charka_
charkhas20285023charkhas
charks155219703char_ks
charms135218843char_ms
charnel124010053charnel
charnels13328173charnels
charpai1436633charpai
charpais1536933charpais
charros124312143charros
charrs115219193char_rs
chars105936643char__s
charts115823093char_ts
chaunts1267083chaunts
chazans21268123chazans
chinas115119403ch_inas
choreas124414203choreas
churns114910233churn_s
czardas1934673czardas
czarinas1935303czarinas
dachas124113253d_achas
dadas75819863d_a_das
daggas937973d_aggas
dahlias1135723dahlias
damans94715983d_amans
damns84916923d_amn_s
dangs75623203d_a_ngs
dans56748153d_a_n_s
darbar959953d_arbar
darbars10510093d_arbars
darbs85323263d_ar_bs
darers75921873d_arers
dares66146703d_ar_es
darics94314113d_arics
darings93713653d_arings
darks106727873d_ar_ks
darn56434623d_arn__
darned85018483d_arned
darnel74312183d_arnel
darnels83710433d_arnels
darner74017303d_arner
darners83815773d_arners
darts67635733d_ar_ts
daunts75014083d_aunts
dawns95916593d_awn_s
deans66131393dea_n_s
dearies83526273dearies
dearness939973dearness
dears65736883dear__s
dearths11498843dearths
dehorns11428363dehorn_s
dermas94116813d_ermas
dhaks13479703dha__ks
dhals95415443dha__ls
dharmic1535023dharmic
dhooras1135943dhooras
dhourras1252233dhourras
diaries83321953diaries
diurnal844883diurnal
diurnals943803diurnals
dobras94811913dobr_as
donas65926473d__onas
donnas75511323d_onnas
douras75016723dour_as
dracenas1145793dracenas
drains73719403drain_s
dramas95814663dra_mas
duennas834143duennas
duras65727733d_ur_as
durns64819873d_urn_s
durras74713373d_urras
dwarfs13436273dwar_fs
dwarves1434463dwarves
earns55927563_earn_s
faenas94412763_faenas
farinas103215243_farinas
faunas94013633_faunas
gharial1137343gharial
gharials1245123gharials
gharris11306433gharris
goannas836223goannas
guaranas995943guaranas
hahas117118443_ha_has
haints94417583_haints
halmas117017893_halmas
halvas124714173_halvas
hamzas20119013_hamzas
hands95327383_ha_nds
hangs95726723_ha_ngs
hanks126226863_ha_nks
hansa85416783_ha_nsa
hansas94616043_hansas
hants86335403_ha_nts
harass9313943_harass
hardass1139753_hardass
hards96435653_har_ds
harems115513823_harems
hares86255543_har_es
harianas1139163_harianas
harks126333433_har_ks
harls85634503_har_ls
harms106829013_har_ms
harness102413933_harness
harps105926873_har_ps
hartal9415473_hartal
hartals10313023_hartals
harts88441593_har_ts
haunts95614393_haunts
hazans183411653_hazans
hennas94211803_hennas
hernias10310773_hernias
herns84825583_hern_s
horas86333103_hor_as
horns86125333_horn_s
hyaenas1334983hyaenas
hyenas1288953_hyenas
jarinas143712193_jarinas
jnanas13207303jna_nas
kahunas1473953kahunas
kanas95326913_ka_nas
karmas123013733_karmas
karns96624143_karn_s
khans124615173kha_n_s
larvas9310233_larvas
learns65513743learn_s
lianas63713383lia_nas
manas76240433_ma_nas
mannas85019803_mannas
maras75443293_mar_as
marinas93519393_marinas
markas124717003_markas
nanas55928633_na_nas
ocarinas1036733ocarinas
paras76143043_par_as
parkas125018023_parkas
pharos11312063phar_os
piranas9912603piranas
prajnas1635453prajnas
puranas9712643puranas
rhamnus1233133rhamnus
ruanas6311263rua_nas
sarans64224433_sarans
saunas63915433_saunas
shairns10276783shairn_s
shamans123610903shamans
shamas113717943sha_mas
shammas14358723shammas
shanks135315583sha_nks
shards104319173shar_ds
sharers104720623sharers
shares95236413shar_es
sharia93116733sharia_
shariah132210533shariah
shariahs14206393shariahs
sharifs13279903sharifs
sharks135019723shar_ks
sharn84823703sharn__
sharny124711833sharn_y
sharps115516083shar_ps
sherpas1238093sherpas
shorans102812413shorans
tarnal63716503_tarnal
tarns56433953_tarn_s
teargas837013teargas
thanes94918983tha_nes
thanks134313133tha_nks
tharms115712243thar_ms
thorias102312053thorias
thorns95314103thorn_s
tiaras6314553tiar_as
tsarinas835273tsarinas
tzarinas1733973tzarinas
varas86028193_var_as
varias95019903_varias
varna84516173_varna_
warns87231003_warn_s
whangs13439723wha_ngs
wharfs1546373whar_fs
wharves16457133wharves
whenas124610463wh_enas
whereas13448903whereas
yarns85621793_yarn_s
yearns9509543yearn_s

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.406440125.6
2DLD Change Limit1340272236.42320866.7
3Display Results2232230.0762934.2
 (SQL Overall)1786912236.90525878.5
 
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.