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

251 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
dharmas135650(None) 
dharma1276101dharma_
dharnas1155371dharnas
chacmas1637992chacmas
charas114223592char_as
charkas164810952charkas
charms135218832charm_s
dermas94116812d_ermas
dharmic1535012dharmic
dharna1055262dharna_
dhurnas1153442dhurnas
dramas95814652dra_mas
halmas117017892_halmas
harms106829012_harm_s
karmas123013732_karmas
shamas113717932sha_mas
shammas14358712shammas
sharias102516002sharias
tharms115712242tharm_s
agamas97413443aga_mas
agmas85919873__agmas
alarms85913053alarm_s
almas76629773__almas
amas67746293__a_mas
areas55935773__areas
arias55438023__arias
arms66137493__arm_s
aromas81018613__aromas
arras55626133__arras
asramas938303asramas
atmas75721013__atmas
barcas101016603_barcas
barman103519703_barman
barms96128463_barm_s
bhaktas1633643bhaktas
bharal1138893bhar_al
bharals1236733bharals
brahmas1436733brahmas
camas96333523_ca_mas
carman103920743_carman
chacma1537903chacma_
chairman15106373chairman
chairmans1685133chairmans
chakras16428483chakras
challas124414123challas
champs154915683cha_mps
chams126028503cha_m_s
chapman1637893chapman
chards125119723char_ds
chares115631803char_es
charges134615983charges
charismas1655293charismas
charka154011703charka_
charkhas20285023charkhas
charks155219703char_ks
charm126124663charm__
charmed154714243charmed
charmer144913663charmer
charmers154211323charmers
charpai1436623charpai
charpais1536923charpais
charros124312143charros
charrs115219183char_rs
chars105936633char__s
charts115823093char_ts
chasmal14158213chasmal
chasms135513143chasm_s
chiasmas15306583chiasmas
chirms135113983chirm_s
choreas124414203choreas
chromas142512683chromas
czardas1934673czardas
dachas124113253d_achas
dadas75819863d_a_das
daggas937973d_aggas
dahlias1135723dahlias
daman84821163d_a_man
damans94715983d_a_mans
damar84117733d_a_mar
damars93814993d_a_mars
damask1335843d_a_mask
dames85435853d_a_mes
dammar11438903d_ammar
dammars12308193d_ammars
damns84916923d_a_mns
damps105220413d_a_mps
dams77444373d_a_m_s
darbar959953d_arbar
darbars10510093d_arbars
darbs85323263d_ar_bs
darers75921873d_arers
dares66146703d_ar_es
darics94314113d_arics
darks106727873d_ar_ks
darns66927893d_ar_ns
darts67635733d_ar_ts
deadman11238423deadman
dearies83526273dearies
dears65736883dear__s
dearths11498843dearths
derma84918513d_erma_
dermal93614343d_ermal
dermis94717163d_ermis
derms85022893d_erm_s
dhaks13479703dha__ks
dhals95415443dha__ls
dhooras1135943dhooras
dhourras1252233dhourras
dhurna1043563dhurna_
diagrams1246133diagrams
diaries83321953diaries
digammas1442983digammas
dioramas1145503dioramas
dirams94413703diram_s
disarms1039043disarm_s
dobras94811913dobr_as
dogmas105011243d_ogmas
dolmas95213043d_olmas
doorman1037063doorman
doormat1059073doormat
doormats1145413doormats
dorms85723833d_orm_s
doumas95314813d_oumas
douras75016723dour_as
drachmas1644863drachmas
drama85117413dra_ma_
drams86025833dra_m_s
drayman1335433drayman
dumas85420433d__umas
duras65727723d_ur_as
durmast1037623d_urmast
durras74713373d_urras
dwarfs13436273dwar_fs
dwarves1434463dwarves
farms106324953_farm_s
gamas85431353_ga_mas
gammas115714693_gammas
gharial1137343gharial
gharials1245123gharials
gharris11306433gharris
gramas94317203gra_mas
grammas12499773grammas
haemal113811643_haemal
haems105517013_haem_s
hahas117118443_ha_has
halma108219253_halma_
halms105225213_halm_s
halvas124714173_halvas
hamal104623103_ha_mal
hamals114816813_ha_mals
hames106138703_ha_mes
hammal134512063_hammal
hammals14409213_hammals
hammam12419333_hammam
hammams13386433_hammams
hams96446133_ha_m_s
hamzas20119013_hamzas
hansas94616043_hansas
harass9313943_harass
hardass1139753_hardass
hards96435653_har_ds
harems115513823_harems
hares86255543_har_es
harks126333433_har_ks
harls85634503_har_ls
harm95637793_harm__
harmed125218833_harmed
harmer114719553_harmer
harmers124116593_harmers
harmin113117393_harmin
harmins123716713_harmins
harps105926863_har_ps
hartal9415473_hartal
hartals10313023_hartals
harts88441593_har_ts
hazmat20312263_hazmat
hazmats2136603_hazmats
herma105318883_herma_
hermae115314473_hermae
hermai118912843_hermai
herms105626433_herm_s
horas86333093_hor_as
ihrams1137173ihram_s
inarms8410093inarm_s
karma113415003_karma_
kormas124511233_kormas
lamas75532793_la_mas
larvas9310233_larvas
llamas888973lla_mas
magmas115512503_magmas
mahatmas1543863mahatmas
mamas95930773_ma_mas
mammas94616403_mammas
maras75443283_mar_as
markas124717003_markas
miasmas1167743miasmas
paras76143043_par_as
parkas125018023_parkas
pharmacy2043243pharmacy
pharos11312063phar_os
plasmas113010753plasmas
rearms85114653rearm_s
shaman113314273sha_man
shamans123610893sha_mans
shames114726223sha_mes
shammash18293743shammash
shammes144312833shammes
shammos14307203shammos
shamos114216983sha_mos
shams105829413sha_m_s
shamus114112813sha_mus
shards104319173shar_ds
sharers104720623sharers
shares95236413shar_es
sharia93116723sharia_
shariah132210533shariah
shariahs14206393shariahs
sharifs13279903sharifs
sharks135019723shar_ks
sharns95516983shar_ns
sharps115516083shar_ps
shawms14579563shawm_s
sherpas1238093sherpas
smarms105712533smarm_s
swarms116112163swarm_s
taramas9612693_taramas
tarmac10310333_tarmac
tarmacs1138323_tarmacs
teargas837013teargas
thairms1244453thairm_s
tharm105916643tharm__
thermae125310493thermae
thermal125010963thermal
thermals13518513thermals
thermes126214613thermes
thermos124610753thermos
therms115914873therm_s
thirams1236803thirams
thorias102312043thorias
tiaras6314533tiar_as
traumas938583traumas
ulamas8910453ula_mas
unarms839243unarm_s
varas86028193_var_as
varias95019903_varias
varnas94212823_varnas
warms107726853_warm_s
whams135515643wha_m_s
wharfs1546373whar_fs
wharves16457133wharves
whereas13448903whereas

Search took 8 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.1561145455.1
2DLD Change Limit1340272517.61017612.0
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.85922737.1
 
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.