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

269 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
bharals123673(None) 
bharal1138891bharal_
baals76122702b_a_als
borals86721912b_orals
charas114223612chara_s
chorals124614112chorals
gharials1245122gharials
halals95018312_halals
hamals114816822_hamals
harass9313942_harass
harls85634502_har_ls
hartals10313022_hartals
aals49941143__a_als
abfarads1443163abfarads
araks94820883__araks
argals75517713__argals
arils58732203__arils
aryls87015813__aryls
astrals75515243astrals
atabals938413atabals
baal67033113b_a_al_
baas66844673b_a_a_s
babas96325733b_aba_s
babels105216723b_abels
babuls105413643b_abuls
badass949293b_adass
bagass938933b_agass
bagels95712313b_agels
bails75933523b_a_ils
balas76937213b_ala_s
balls76236413b_a_lls
bals66354043b___als
banal75925993b_anal_
barbal104016663b_arbal_
barbels114514433b_arbels
barbes104526233b_arbes
barbs95928193b_ar_bs
barcas101016603b_arcas
bardes95026933b_ardes
bards87139643b_ar_ds
barely114716793b_arely
bares75457133b_ar_es
barfly14339653b_arfly
barfs104826003b_ar_fs
barges94528253b_arges
barks115735813b_ar_ks
barms96128463b_ar_ms
barns76335143b_ar_ns
barons85025383b_arons
barrels94514363barrels
barres84427543b_arres
bars66564093b_ar__s
baryes116218503b_aryes
basal75722283b_asal_
basalt83519583b_asalt
basalts9358963b_asalts
basils85717473b_asils
bawls105719323b_a_wls
bazars174613113b_azars
bearable121512363bearable
bearably15177933bearably
bearcats1267023bearcats
beards94116673bear_ds
bearers94619593bearers
bears75739043bear__s
becrawls1543623becrawls
bedrails1136293bedrails
beheadals1542093beheadals
beryls11107883b_eryls
betrays12127823betrays
bewraps14135403bewraps
bewrays15145113bewrays
bhaktas1633643bhaktas
bhaktis1633433bhaktis
bhangras1443693bhangra_s
bhangs12449663bha_ngs
biaxal1536093biaxal_
birls74023163b_ir_ls
blares85021633blar_es
boards94616933boar_ds
boars75229603boar__s
boarts84716873boar_ts
boatels93510233boatels
boral75831703b_oral_
boras75938303b_ora_s
bradawls1443673bradawls
brads85528293b__rads
braes75735053b__raes
brags85625103b__rags
brails84621293bra_ils
brans75437433b__rans
bras65746453b__ra_s
brasils9410973brasils
brass75428023b__rass
brats75336013b__rats
bravas114913323brava_s
brawls115214333bra_wls
braws106425193b__raws
brays106723113b__rays
brazas175812433braza_s
brazils1867753brazils
bridals1038623bridals
bromals1139743bromals
bubals103513843b_ubals
burans85019303b_urans
buras74736303b_ura_s
burials93612083burials
burls74228853b_ur_ls
buttals938503buttals
butyrals1344503butyrals
bwanas1157443bwana_s
byrls105711233b_yr_ls
cabals104020153_cabals
canals84421663_canals
carats85929023_carats
carls77037423_car_ls
carols85124983_carols
carpals113414623_carpals
chadars1338293chadars
chakras16428503chakra_s
chalahs15289883chalahs
challas124414123challas
chapels14429153chapels
charade13129913charade
charades141310853charades
charases131312763charases
charcoals16174683charcoals
chards125119733char_ds
chares115631803char_es
charges134615983charges
charily15310283charily
charkas164810963charkas
charks155219703char_ks
charms135218843char_ms
charnels13328173charnels
charpais1536933charpais
charros124312143charros
charrs115219193char_rs
chars105936643char__s
charts115823093char_ts
chazans21268123chazans
chiral114614413chiral_
chlorals13148033chlorals
choral115118493choral_
chorale124313353chorale
chorales133712883chorales
churls115411073chur_ls
citrals91111673citrals
corals85325143_corals
corrals93713853corrals
craals84113303cra_als
dhals95415443dh__als
dharmas1356513dharmas
dharnas1155373dharnas
earls56127513_ear_ls
farads104713273_farads
farfals13268503_farfals
farls85731113_far_ls
ferals94216643_ferals
florals104210063florals
gayals1039513_gayals
gharial1137343gharial_
gharris11306433gharris
gnarls74210773gnar_ls
goorals838703goorals
gorals76917653_gorals
graals74112913gra_als
haafs115711163_ha_afs
haars85620473_ha_ars
hadal95518123_hadal_
hahas117118443_haha_s
hails85231643_ha_ils
halal85623593_halal_
halala94715093_halala
halalas104214083_halalas
halls85633783_ha_lls
hamal104623113_hamal_
hamauls12387813_hamauls
hammals14409223_hammals
hardass1139753_hardass
hardly135112833_hardly
hards96435653_har_ds
harems115513823_harems
hares86255543_har_es
harks126333433_har_ks
harl75740003_har_l_
harms106829013_har_ms
harps105926873_har_ps
hartal9415473_hartal_
harts88441593_har_ts
hauls86123733_ha_uls
hawala12368913_hawala
hawalas13348353_hawalas
hazans183411653_hazans
hazels185710083_hazels
heals85733453_h_eals
herald10311343_herald
heralds1137713_heralds
herbals122710603_herbals
herls85226433_her_ls
horahs126313873_horahs
horal86328683_horal_
horas86333103_hora_s
hurls86522713_hur_ls
ihrams1137173ih_rams
jacals1539873_jacals
jarls126120963_jar_ls
karats106420493_karats
kraals10378433kra_als
maras75443293_mara_s
marls75535163_mar_ls
morals85324633_morals
murals84016763_murals
narwals1036983_narwals
nasals63312463_nasals
orals55826483__orals
paras76143043_para_s
parols84722613_parols
parrals94414573parrals
pearls84715393pear_ls
pharaoh1545033pharaoh
pharaohs1644493pharaohs
pharos11312063phar_os
phials1158873ph_ials
plurals936913plurals
ratals64219583_ratals
sabals84618863_sabals
sacrals93311793sacrals
salals65120083_salals
sarans64224433_sarans
scarabs1137293scarabs
shamans123610903shamans
shamas113717943shama_s
sharable131910693sharable
shards104319173shar_ds
sharers104720623sharers
shares95236413shar_es
shariahs14206393shariahs
sharias102516003sharias
sharifs13279903sharifs
sharks135019723shar_ks
sharns95516983shar_ns
sharply15406833sharply
sharps115516083shar_ps
shauls94913113sha_uls
shawls125411973sha_wls
sheals94420643sh_eals
shoals94215793sh_oals
shorans102812413shorans
shorls94516203shor_ls
snarls64016873snar_ls
spirals93212513spirals
tamals84116633_tamals
tarsals72512603_tarsals
tharms115712243thar_ms
thermals13518533thermals
thirams1236823thirams
thirls95012063thir_ls
thrall93810293th_rall
thralls10299043thralls
thraws129211103th_raws
thurls9418713thur_ls
tiaras6314553tiara_s
varas86028193_vara_s
wharfs1546373whar_fs
wharves16457133wharves
wheals124512523wh_eals
whirls124710533whir_ls
whorls124410163whor_ls

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.470380193.6
2DLD Change Limit1340272696.09321996.9
3Display Results2692690.0932892.5
 (SQL Overall)1786912696.65626846.6
 
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.