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

358 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
halalas10421408(None) 
halala94715091halala_
halalah13429391halalah
halalahs14367441halalahs
halals95018311halal_s
hawalas13348351hawalas
balatas9311832balatas
cabalas113516002cabalas
callas84526752cal_las
chalazas2245892chalazas
challas124414122chal_las
falbalas1345472falbalas
halachas16317882halachas
halakah17517962halakah
halakahs18426632halakahs
halakhas18386722halakhas
halal85623592halal__
halavah16447022halavah
halavahs17415792halavahs
hallah124115402hal_lah
hallahs133912462hallahs
hallal94415562hal_lal
halloas104318462halloas
hallos95425102hal_los
halls85633782hal_l_s
halmas117017892hal_mas
halvas124714172hal_vas
hamadas1339672hamadas
hamals114816822hamal_s
hawala12368912hawala_
hollas94616902hol_las
kabalas133911062kabalas
kamalas13339122kamalas
masalas9312052masalas
palapas11311492palapas
qabalas18289502qabalas
salals65120082salal_s
wallas95719392wal_las
aals49941143_a_al_s
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
agamas97413453_agamas
akelas10311193_akelas
alamos8415003_alamos
alands75418373_alands
alans55636173_ala_ns
alants67722023_alants
alarms85913053_alarms
alas46358123___alas
alaskas1136683_alaskas
alates64833963_alates
albas75925393_al_bas
albatas938373_albatas
alfalfas1441953_alfalfas
alfas87219043_al_fas
algas65624933_al_gas
alias55834603_al_ias
aliyas93911803_aliyas
alkalis11148793_alkalis
allay85620393_al_lay
allays94313743_allays
alls46740923_al_l_s
almas76629773_al_mas
alohas9411703_alohas
alpacas1137073_alpacas
alphas1139513_alphas
alula5317093_alula_
alulae6312743_alulae
alular6311353_alular
anabas8314083_anabas
anlas55626933_a_nlas
argalas84011093argalas
asanas6514113_asanas
atalayas1144783atalayas
atlas55821583_a_tlas
azaleas1636993_azaleas
baals76122703ba_al_s
bacalao1146613bacalao
bacalaos1245863bacalaos
baklavas1742783baklavas
baklawas1743213baklawas
balas76937213__balas
balases93815433balases
balata8614673balata_
balboas113710073balboas
ballad94315323bal_lad
ballads104212913ballads
ballast9313993bal_last
balls76236413bal_l_s
balsas86417523bal_sas
bananas93312223bananas
basalts9358963basalts
bharals1236733bharal_s
cabala103516913cabala_
cabals104020153cabal_s
cabanas112413033cabanas
cabbalas1467373cabbalas
calabash1544253calabash
calamar1149293calamar
calamars1238133calamars
calamus1139243calamus
calesas9411833calesas
calla74827073cal_la_
callan83619603cal_lan
callans94518473callans
calls75634733cal_l_s
callus85317073cal_lus
canals84421663canal_s
canolas9313993canolas
cantalas104013523cantalas
canulas9312853canulas
casabas1139983casabas
casavas1237813casavas
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
cavallas1366843cavallas
chalahs15289883chala_hs
chalaza2145733chalaza_
chalazae2244423chalazae
chalazal2243873chalazal
challa114014193chal_la_
challah15458323chal_lah
challahs16377563challahs
challis124613463chal_lis
chalupas1554383chalupas
chollas123811353chol_las
cicalas1139303cicalas
coalas87418963_coalas
dalasis8810533dalasis
dalles74222063dal_les
falbala1235873falbala_
fallal93612693fal_lal
fallals103310193fallals
falls85727653fal_l_s
favelas1337023favelas
fellas95116963fel_las
galabias1137733galabias
galagos938143galagos
galahs105512673gala_hs
galangas1046173galangas
galas65731643__galas
galateas937133galateas
galaxes1538873galaxes
galeas74618513gal_eas
galenas83310343galenas
galls64729323gal_l_s
gallus74313203gal_lus
gayals1039513gayal_s
geladas936313geladas
haafs115711163ha_a_fs
haars85620473ha_a_rs
habdalah1742623habdalah
habdalahs1842113habdalahs
hackles162917063hackles
hadal95518123hadal__
haftaras14136073haftaras
haggadas1463633haggadas
haggles123312483haggles
hahas117118443h__ahas
hails85231643ha_il_s
halacha15388003halacha
halakha17416583halakha
halakhah17384763halakhah
halakhahs18393133halakhahs
halakic1656663halakic
halakist15158223halakist
halers94926913hal_ers
hales85449843h__ales
halfway1943763halfway
halides113416663halides
halids104016133hal_ids
halites103221193halites
halitus10339963halitus
hall75741163hal_l__
hallel93514093hal_lel
hallels103310133hallels
hallo85127553hal_l_o
halloa94918123hal_loa
halloes104021523halloes
halloo95118973hal_loo
halloos103716743halloos
hallot95426783hal_lot
hallow124818323hal_low
hallows134417393hallows
hallux1637363hal_lux
hallway1636173hallway
hallways1745423hallways
halma108219253hal_ma_
halms105225213h__alms
haloes94623863hal_oes
haloids113012553haloids
halons95720713hal_ons
halos85230253h__alos
halters104619803halters
haltless11308443haltless
halts85230103h__alts
halva115414433hal_va_
halvah15499833hal_vah
halvahs16417533halvahs
halvers133311423halvers
halves124717093hal_ves
halyards1576243halyards
hamada1239923hamada_
hamal104623113hamal__
hamates122917683hamates
hamauls12387813hamauls
hammadas1644793hammadas
hammals14409223hammal_s
hamular1236973hamular
hamulus1235323hamulus
hamzas20119013ha_mzas
handles114020653handles
hansas94616043ha_nsas
hantles104117513hantles
haoles94919803ha_oles
hapaxes1936593hapaxes
harass9313943hara_ss
harianas1139163harianas
harls85634503ha_rl_s
hartals10313023hartal_s
hassles103411693hassles
haulages1236623haulages
haulms11558503ha_ulms
hauls86123733ha_ul_s
havdalah1842153havdalah
havdalahs1941883havdalahs
haylages1536013haylages
hazans183411653haza_ns
hazards2037463hazards
hazels185710083hazel_s
heals85733453h_eal_s
hellos95321683hel_los
hells85032043hel_l_s
heralds1137713heralds
hexaplas2043523hexaplas
hilloas104413553hilloas
hillos94618893hil_los
hills85431353hil_l_s
holards1148433holards
holdalls1244333holdalls
holla84918493hol_la_
holloas103814943holloas
hollos95320633hol_los
hooplas1239193hooplas
hulas84920883h__ulas
hulloas103911913hulloas
hullos94916293hul_los
hulls84923563hul_l_s
hylas114815903h__ylas
impalas11236953impalas
jacales16310323jacales
jacals1539873jacal_s
jacanas1638263jacanas
jalaps15299183jala_ps
kabakas12367403kabakas
kabala124011553kabala_
kabayas16316803kabayas
kabbalas1674353kabbalas
kalams12310603kala_ms
kalmias1347973kalmias
kalpas124112943kal_pas
kamala12339963kamala_
kanakas10327213kanakas
khalifas1842513khalifas
koalas104011663_koalas
lallan63414173lal_lan
lallans74113533lallans
lalls55324133__lalls
lamas75532793__lamas
lavas85422223__lavas
llamas888973_llamas
maculas113114023maculas
malaccas1445163malaccas
malangas1136863malangas
malarias10313773malarias
malars85020683mala_rs
malates93522603malates
malls76233433mal_l_s
malthas1237913malthas
mananas93414733mananas
mandalas1139443mandalas
manilas93915873manilas
maracas11313773maracas
marsalas1038253marsalas
masala8311813masala_
mullas84215933mul_las
naganas847983naganas
nalas55528363__nalas
napalms1144033napalms
nasals63312463nasal_s
nyalas936903_nyalas
ollas54218283_ol_las
paellas9411413paellas
pajamas18278153pajamas
palabras1267353palabras
palaces114216453palaces
palais8420423pala_is
palapa10310673palapa_
palatal9310153palatal
palatals1037773palatals
palates93624933palates
palls74332563pal_l_s
panadas103312213panadas
panamas113112763panamas
papayas1437273papayas
patacas11311003patacas
payolas12148973payolas
phallus1236063phal_lus
playas114612283_playas
plazas17409913_plazas
qabala17399193qabala_
qabalah21285033qabalah
qabalahs22253293qabalahs
radulas839583radulas
ramadas1039303ramadas
ramblas112710263ramblas
ranulas7311773ranulas
ratals64219583ratal_s
sabals84618863sabal_s
salaam8711013sala_am
salaams997703salaams
salads75316963sala_ds
salal55425703salal__
salamis9313513salamis
salinas73116093salinas
salivas10309603salivas
salols64017873salol_s
salpas85116923sal_pas
salsas65316133sal_sas
salvias10279933salvias
samaras9312913samaras
sataras7315063sataras
shillalas12133293shillalas
tablas83716163ta_blas
talars66021683tala_rs
talas55935893__talas
tallis63319963tal_lis
talls55133433tal_l_s
talukas11316213talukas
tamales93216153tamales
tamals84116633tamal_s
tambalas1237033tambalas
tampalas1245473tampalas
tapalos938813tapalos
taramas9612703taramas
thalamus1343603thalamus
thallus1035603thal_lus
ulamas8910453_ulamas
valutas1036533valutas
villas96117263vil_las
walla85321033wal_la_
wallah124011993wal_lah
wallahs13409473wallahs
walls85529383wal_l_s
yamalkas1743103yamalkas
zananas16319563zananas

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.250714764.0
2DLD Change Limit1340273586.59320328.7
3Display Results3583580.1262841.3
 (SQL Overall)1786913586.96925640.8
 
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.