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

278 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
kalmias134797(None) 
kalmia1238891kalmia_
alias55834602_al_ias
almas76629772_alm_as
amias75831472_a_mias
halmas117017892halm_as
kalian10312162kal_ian
kalians11310182kal_ians
kalifs134410982kal_ifs
kalimbas1642322kalimbas
kalpas124112942kal_pas
kamiks11387912ka_miks
karmas123013732karm_as
lamias85020612la_mias
salmis8514272salmi_s
salvias10279932salvias
zamias174212922za_mias
aaliis6312903aal_iis
admits9411413_admits
agmas85919873_agm_as
agrias74315393_agrias
alas46358123_al__as
albas75925393_al_bas
alcids94812293_alcids
alexias14249793_alexias
alfas87219043_al_fas
algas65624933_al_gas
algins74816433_algins
alifs86121263_al_ifs
aliyas93911803_aliyas
alkies104518093_alkies
allies63827673_allies
alma66333023_alm_a_
almah106917253_alm_ah
almahs118611613_almahs
almehs11619493_almehs
almes75126543_alm_es
alms65834923_alm__s
almuds9378773_almuds
almugs9396423_almugs
alohas9411703_alohas
aloins65022203_aloins
alphas1139513_alphas
aluminas1048353_aluminas
alumins9512983_alumins
amas67746293_a_m_as
amia66836903_a_mia_
amids85627513_a_mids
amies76837693_a_mies
amigas95912173_a_migas
amins75534323_a_mins
amirs75924923_a_mirs
amis66445323_a_mi_s
amiss75823073_a_miss
anaemias1069203anaemias
analgias9107803analgias
anemias92512143anemias
animas84418723_animas
arias55438023_a_rias
armies85123693_armies
atmas75721013_atm_as
balas76937213bal__as
balatas9311833balatas
balboas113710073balboas
baldies105317703baldies
ballies93725743ballies
balmier113811513balmier
balmiest124110993balmiest
balmily14216463balmily
balms95723923balm__s
balsas86417523bal_sas
bulimias1254323bulimias
calesas9411833calesas
califs114915893cal_ifs
calkins133814873calkins
callas84526753cal_las
calming123915973calming
calms95222353calm__s
camas96333523ca_m_as
camisa103114323ca_misa
camisas113411923ca_misas
cammies134016483cammies
capias10318353ca_pias
cardias10715123cardias
cassias93514343cassias
dahlias1135723dahlias
daimios1035753daimios
dallies84023193dallies
dolmas95213043dolm_as
dulias71212743dul_ias
facias113415803fa_cias
falsies103515013falsies
fascias1258413fascias
filmis114610283filmi_s
galabias1137733galabias
galas65731643gal__as
galeas74618513gal_eas
galenas83310343galenas
galliass935423galliass
gallicas1136933gallicas
gallies84122713gallies
gamas85431363ga_m_as
gambas115817513ga_mbas
gambias125010733gambias
gamins94420053ga_mins
gammas115714693ga_mmas
glias64618493_gl_ias
haemins122811403haemins
halalas104214083halalas
halids104016133hal_ids
halloas104318463halloas
halma108219253halm_a_
halms105225213halm__s
haloids113012553haloids
halvas124714173hal_vas
hamzas20119013ha_mzas
harmins123716723harmins
jammies183611293jammies
jasmins1637083jasmins
kaas86531843ka___as
kabakas12367403kabakas
kabalas133911063kabalas
kabayas16316803kabayas
kachinas1736343kachinas
kadis105921063ka_di_s
kaffirs17325553kaffirs
kafirs13306983ka_firs
kahunas1473953kahunas
kaiak8310353ka__iak
kaiaks937043ka__iaks
kaifs125715643ka__ifs
kails95525213ka__ils
kainits1137763kainits
kains96125643ka__ins
kakas85117343ka__kas
kakis86116843ka_ki_s
kalam11315113kal__am
kalamatas1543713kalamatas
kalams12310603kal_ams
kalends1235683kalends
kales95730983kal__es
kalif125021363kal_i_f
kalimba1542663kalimba
kaliph1537873kal_iph
kaliphs1634293kaliphs
kalium1239473kal_ium
kaliums1336603kaliums
kalongs1255443kalongs
kalpa114512193kal_pa_
kalpac14428223kal_pac
kalpacs15327133kalpacs
kalpak11437243kal_pak
kalpaks12366163kalpaks
kamalas13339123kamalas
kames115024693ka_m_es
kami105823643ka_mi__
kamik105011553ka_mi_k
kamsins1346963kamsins
kanakas10327213kanakas
kanas95326913ka__nas
kanjis1735963kanji_s
kaolins1139363kaolins
kapas116021733ka__pas
kappas144410363ka_ppas
karma113415003karm_a_
karmic1438113karmi_c
kashas133311903ka_shas
kashmirs17132243kashmirs
katas95922093ka__tas
katcinas1434513katcinas
kauries113613193kauries
kauris103611533kauri_s
kavas125919953ka__vas
kelims1278913kel_ims
kellies113516853kellies
keloids1288663keloids
kelpies13289903kelpies
kelvins14106563kelvins
kermis124012393kermi_s
kerrias11289513kerrias
khalifas1842513khalifas
khalifs1754073khal_ifs
kilims1277903kil_ims
killies113318113killies
kilties113014143kilties
kliks8398823k_l_iks
koalas104011663koal__as
kolas94822233kol__as
kormas124511233korm_as
koumis1237623koumi_s
koumiss1344313koumiss
kumiss1235923k_umiss
lamas75532793la_m_as
lamia75324323la_mia_
lamiae84817453la_miae
laminas93615873la_minas
lampas106615953la_mpas
latrias71913213latrias
limas75627633__limas
llamas888973llam_as
maffias15327283maffias
mafias113913573ma_fias
magmas115512503magm_as
malarias10313773malarias
malkins133311803malkins
malmier113611953malmier
malmiest123211023malmiest
malms95021553malm__s
malthas1237913malthas
mamas95930773ma_m_as
mambas125716243ma_mbas
mamies104626243ma_mies
mammas94616403ma_mmas
mammies104314763mammies
manias84029033ma_nias
myalgias14123893myalgias
nalas55528363nal__as
otalgias944183otalgias
palais8420423palai_s
palapas11311493palapas
pallia83015593pallia_
pallial92911253pallial
palmar104113463palm_ar
palmers113513623palmers
palmier113312173palmier
palmiest123212033palmiest
palming123914013palming
palmist112814343palmist
palmists12268813palmists
palms94921753palm__s
palmyras1544033palmyras
palsies94420273palsies
pampas124913993pa_mpas
pyaemias1545063pyaemias
pyemias1436803pyemias
raffias13237713raffias
raias54631123ra__ias
rallies73823343rallies
ramies84630463ra_mies
raphias123511083raphias
saimins9312113saimins
salamis9313513salami_s
salinas73116093salinas
salivas10309603salivas
sallies73227813sallies
salmi7815863salmi__
salmons93713263salmons
salpas85116923sal_pas
salpian938493salpian
salpians1036763salpians
salpids1038193salpids
salsas65316133sal_sas
salties73725773salties
salvia93310753salvia_
sambas104219263sa_mbas
taenias7311283taenias
taffias13377413taffias
tafias93111963ta_fias
talas55935893tal__as
talkies113415733talkies
tallies73624603tallies
tallis63319963talli_s
tallits73215993tallits
talukas11316213talukas
tamis76728733ta_mi_s
tammies113814683tammies
tarsias74013373tarsias
ulamas8910453ulam_as
uraemias1046043uraemias
uremias9249503uremias
valonias1147473valonias
valutas1036533valutas
varias95019903va_rias
walies95324523wal_ies
wallas95719393wal_las
wallies103320743wallies
yautias1046333yautias
zamia165115213za_mia_

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.390458182.1
2DLD Change Limit1340272786.62620227.4
3Display Results2782780.1102527.3
 (SQL Overall)1786912787.12625075.9
 
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.