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

128 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
bhaktas163364(None) 
bhakta1533651bhakta_
bhaktis1633431bhaktis
bhakti1544332bhakt_i
chakras16428502chakras
abakas123911743abak_as
antas55432033__antas
baas66844673b_a__as
babas96325733b_a_bas
babkas146010143b_abkas
bahts105617803b_aht_s
baits76630583b_ait_s
baizas173810823b_aizas
bakers125323453b_akers
bakes117035373b_ak_es
balas76937213b_a_las
balatas9311833balatas
balsas86417523b_alsas
bandas95120543b_andas
bantam10314063b_antam
bantams1149063b_antams
barcas101016603b_arcas
barytas12378283barytas
bastes85330383b_astes
basts75936933b_ast_s
bates75846343b_a_tes
baths105922923b_a_ths
bats66962333b_a_t_s
batts76727563b_a_tts
beakers134216873beakers
beaks115326623beak__s
beasts84519723beast_s
beats76042243bea_t_s
beauts86015283beaut_s
betas75528763b__etas
bettas84913923b_ettas
bhangras1443693bhangras
bhangs12449663bha_ngs
bharal1138893bha_ral
bharals1236733bharals
bhoots11459913bhoot_s
bhuts105812953bh_ut_s
biotas84313923b_iotas
blasts85116773blast_s
blats75132503bla_t_s
boarts84716873boart_s
boasts85017923boast_s
boats75635153boa_t_s
bonitas939453bonitas
botas75328783b__otas
bracts105617773bract_s
brahmas1436733brahmas
brakes124923123brak_es
brants85723053brant_s
brats75336013bra_t_s
bravas114913323bra_vas
brazas175812433bra_zas
buckras1537343buckras
burkas124513803burk_as
bwanas1157443bwa_nas
chacmas1638003chacmas
chaeta11310683chaeta_
chaetae1238603chaetae
chaetal1238283chaetal
chakra15437533chakra_
challas124414123challas
chants115020393chant_s
charas114223613cha_ras
charkas164810963charkas
charkhas20285023charkhas
charts115823093chart_s
chats105730093cha_t_s
chukkas1532783chukkas
dhaks13479703dhak__s
dharmas1356513dharmas
dharnas1155373dharnas
exactas16336433exactas
flautas1036153flautas
ghats95818613gha_t_s
ghauts10447783ghaut_s
haets86525123_haet_s
hafts116219463_haft_s
hahas117118443_ha_has
hakes126034303_hak_es
hakims1537303_hakims
hakus125114113_hak_us
halmas117017893_halmas
halts85230103_halt_s
halvas124714173_halvas
hamzas20119013_hamzas
hansas94616043_hansas
hants86335403_hant_s
hartal9415473_hartal
hartals10313023_hartals
harts88441593_hart_s
hastes95727073_hastes
hates86742573_ha_tes
hats76858253_ha_t_s
hostas94515823_hostas
kakas85117343_kak_as
katas95922093_ka_tas
khakis1265853khak_is
khats125316013kha_t_s
mantas85725363_mantas
nakfas1334683_nakfas
pastas85422873_pastas
phantasm1554133phantasm
phantast1346923phantast
phantasy1643463phantasy
raitas64417673_raitas
reatas64021013rea_tas
riatas63915093ria_tas
shafts125411443shaft_s
shaitan1036893shaitan
shaitans1136413shaitans
shakers144015563shakers
shakes135024593shak_es
shakoes144510023shakoes
shakos134912193shak_os
shamas113717943sha_mas
shammas14358723shammas
shantis103313103shantis
sharias102516003sharias
sheltas10279673sheltas
shiksas1484643shiksas
takas95520683_tak_as
thetas93011573th_etas
whats117718993wha_t_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 Limit1340271286.11021935.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911286.56227231.2
 
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.