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

473 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
hallah12411540(None) 
challah15458321challah
halalah13429391halalah
hallahs133912461hallahs
hallal94415561hallal
halvah15499831halvah
wallah124011991wallah
allay85620392_allay
almah106917252_almah
ballad94315322ballad
calla74827072calla_
callan83619602callan
callas84526752callas
chalah143511662cha_lah
challa114014192challa_
challahs16377562challahs
challas124414122challas
fallal93612692fallal
fellah124910772fellah
galah95917632ga_lah
halakah17517962halakah
halal85623592ha_lal
halala94715092halala
halalahs14367442halalahs
halalas104214082halalas
halals95018312halals
halavah16447022halavah
hall75741162hall__
hallel93514092hallel
hallo85127552hall_o
halloa94918122halloa
halloas104318462halloas
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
halloth134111252halloth
hallow124818322hallow
halls85633782hall_s
hallux1637362hallux
hallway1636172hallway
halma108219252halma_
halmas117017892halmas
halva115414432halva_
halvahs16417532halvahs
halvas124714172halvas
hamzah23135562hamzah
holla84918492holla_
hollas94616902hollas
lallan63414172lallan
mollah11319452mollah
mullah113710732mullah
nullah9388142nullah
walla85321032walla_
wallahs13409472wallahs
wallas95719392wallas
zillah1836562zillah
aah616252963_a__ah
ala312463603_a_la_
alae45643753_a_lae
alan46844083_a_lan
alar46340073_a_lar
alas46358123_a_las
alba68328333_alba_
albas75925393_albas
aleph10311393_aleph
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algal66518223_algal
algas65624933_algas
alias55834603_alias
aliyah12397493_aliyah
all36148233_all__
allays94313743_allays
allee54932123_allee
alley85721673_alley
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
alls46740923_all_s
ally76935643_all_y
allyl85310543_allyl
alma66333023_alma_
almahs118611613_almahs
almas76629773_almas
almeh106214553_almeh
aloha8513613_aloha
alpha1049653_alpha
altar55520643_altar
alula5317093_alula_
alulae6312743_alulae
alular6311353_alular
alway116113923_alway
amah98927493_a_mah
anlas55626933_anlas
atlas55821583_atlas
ayah108022993_a_yah
balas76937213ba_las
ball66043323ball__
ballade104012563ballade
ballads104212913ballads
ballast9313993ballast
balled94926893balled
baller83825203baller
ballet84733973ballet
ballon84117493ballon
ballot84624093ballot
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
blah98625063__blah
bulla74620563bulla_
bullae83416163bullae
calash11312433calash
calcar10312753calcar
caliph13311403caliph
call66838673call__
callans94518473callans
callant94121223callant
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
callow114714663callow
calls75634733call_s
callus85317073callus
calpac123211063calpac
casbah1337903casbah
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
chalahs15289883cha_lahs
chaleh143711993cha_leh
challie124012853challie
challis124613463challis
challot123613263challot
challoth16316103challoth
chally144314293chall_y
chaloth15298603chaloth
cholla113911023cholla_
chollas123811353chollas
collar83816173collar
cullay113910173cullay
daledh1133743daledh
daleth1038633daleth
dalles74222063dalles
dally95324743dall_y
dollar74110983dollar
earlap837183earlap
fall75535313fall__
fallacy1536433fallacy
fallals103310193fallals
fallen93813373fallen
faller94621233faller
fallow124713853fallow
falls85727653fall_s
fella84918653fella_
fellahs13428393fellahs
fellas95116963fellas
fullam1138363fullam
gala55635163ga_la_
galahs105512673ga_lahs
galas65731643ga_las
galax135314463ga_lax
galea64722933galea_
galeae74717453galeae
galeas74618513galeas
gall56335993gall__
gallant83517113gallant
gallate83417123gallate
galled84622863galled
gallet73630853gallet
galley104215453galley
gallic9411643gallic
gallon73715813gallon
gallop93311383gallop
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galosh1038563galosh
galyac1235973galyac
galyak1445333galyak
ganjah17145503ganjah
haaf106227733ha__af
haar77323493ha__ar
habdalah1742623habdalah
hadal95518123ha_dal
hadith13312063hadith
haemal113811643haemal
hah910655223h___ah
haha107821063ha_ha_
hahas117118443ha_has
haika125313793haika_
hail74839063hail__
hailed104122743hailed
hailer94720343hailer
hails85231643hail_s
halacha15388003halacha
halakahs18426633halakahs
halakha17416583halakha
halakhah17384763halakhah
halavahs17415793halavahs
hale76052833ha_l_e
haled95335823ha_led
haler85033523ha_ler
halers94926913halers
haleru94212073haleru
hales85449843ha_les
halest94823273halest
half106238453ha_l_f
halfway1943763halfway
halid94424983ha_lid
halide103417993halide
halids104016133halids
haling104229783haling
halite93624233halite
hallels103310133hallels
halliard12125963halliard
hallmark1744213hallmark
halloaed121510153halloaed
halloed113314913halloed
halloes104021523halloes
halloos103716743halloos
hallows134417393hallows
hallucal1343483hallucal
hallways1745423hallways
halm95834973ha_l_m
halms105225213ha_lms
halo76437323ha_l_o
haloed104717603haloed
haloes94623863haloes
haloid104317763haloid
halon86124863ha_lon
halons95720713halons
halos85230253ha_los
halt76056303ha_l_t
halted105019603halted
halter94420883halter
halts85230103ha_lts
halutz1868853halutz
halve114818923ha_lve
halved134813903halved
halves124717093halves
halyard1476973halyard
hamal104623113ha_mal
hamals114816823hamals
hamlet113722793hamlet
hammal134512063hammal
hammam12419333hammam
hamular1236973hamular
hamza19139773hamza_
hamzahs24134373hamzahs
hamzas20119013hamzas
handax1749583handax
hangar104114513hangar
hansa85416783hansa_
hansas94616043hansas
haole84820083haol_e
haoles94919803haoles
hapax1739323ha_pax
haply135915063hapl_y
harl75740003harl__
harlot94422803harlot
harls85634503harl_s
harsh116418053ha_rsh
hartal9415473hartal
hash106936503ha__sh
haslet93222713haslet
hatch135719593ha_tch
hath105933913ha__th
haugh125114053ha_ugh
haul75530453haul__
haulage1136913haulage
hauled104415213hauled
hauler95015123hauler
haulm104415413haul_m
haulms11558503haulms
haulmy14455553haulmy
hauls86123733haul_s
haunch14377343haunch
havdalah1842153havdalah
hawala12368913hawala
hawalas13348353hawalas
haylage1436443haylage
hazan173813613ha_zan
hazmat20312263hazmat
hazzan17236803hazzan
health124712143health
heliac111010893heliac
hell75637893hell__
hellcat12410173hellcat
helled104024703helled
heller93322513heller
hellish13310723hellish
hello86522983hell_o
hellos95321683hellos
hells85032043hell_s
hijrah1934283hijrah
hila76228353h_ila_
hilar85418143h_ilar
hill76439493hill__
hilled104022223hilled
hiller94421633hiller
hillo84721653hill_o
hilloa94713033hilloa
hilloas104413553hilloas
hillos94618893hillos
hills85431353hill_s
hilly114422163hill_y
hollaed11359853hollaed
holland11349473holland
holler93520613holler
hollo84822163holl_o
holloa94914823holloa
holloas103814943holloas
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
holly114824433holl_y
hookah16488243hookah
hoorah124411113hoorah
horah117922053h_orah
houdah1335173houdah
howdah1634723howdah
hula74923753h_ula_
hulas84920883h_ulas
hull75428783hull__
hulled103920013hulled
huller93919103huller
hullo84417453hull_o
hulloa95011183hulloa
hulloas103911913hulloas
hulloo94511733hulloo
hullos94916293hullos
hulls84923563hull_s
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
hyla106716513h_yla_
hylas114815903h_ylas
jalap143612473ja_lap
jarrah1636683jarrah
kalam11315113ka_lam
kalian10312163kalian
kaliph1537873kaliph
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
kasbah1535183kasbah
keblah1545313keblah
kiblah1535583kiblah
lall45531313lall__
lalland83810183lalland
lallans74113533lallans
lalled74218753lalled
lalls55324133lall_s
malar76424443ma_lar
mall64639373mall__
mallard10310273mallard
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
mallow114014743mallow
malls76233433mall_s
maltha1137503maltha
matsah1138233matsah
matzah2035963matzah
mollahs12328283mollahs
moolah11409193moolah
mulla74317113mulla_
mullahs12388733mullahs
mullas84215933mullas
nala46930393na_la_
nalas55528363na_las
nullahs10316993nullahs
olla44821173_olla_
ollas54218283_ollas
paella8410913paella_
paellas9411413paellas
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
palish114718273palish
pall65039343pall__
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallial92911253pallial
pallid93915283pallid
pallor8313673pallor
palls74332563pall_s
pally105727123pall_y
palmar104113463palmar
palpal104112053palpal
pardah123412823pardah
pariah114320583pariah
parlay113713993parlay
phalli1148263phall_i
phallic1447293phallic
phallus1236063phallus
pillar8314023pillar
qabalah21285033qabalah
raglan73711503raglan
rajah155711423ra_jah
rally84725903rall_y
rallye95110163rallye
ralph1078743ra_lph
rayah116013503ra_yah
salaam8711013salaam
salad65321833sa_lad
salal55425703sa_lal
salals65120083salals
sall44544683sall__
sallet63734543sallet
sallow94315753sallow
sally85129713sall_y
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
selah8319613_selah
shall85024053shall__
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shariah132210533shariah
shellac1236693shellac
tabla73318363tabla_
tablas83716163tablas
tala45938053ta_la_
talar56225383ta_lar
talas55935893ta_las
tall47240213tall__
tallage82712073tallage
taller63721963taller
tallis63319963tallis
tallish103313583tallish
tallit63422733tallit
tallith102913063tallith
tallol63612223tallol
tallow93714203tallow
talls55133433tall_s
tally84526863tall_y
tallyho1343043tallyho
thalli958923thall_i
thallic1246553thallic
thallus1035603thallus
vallate103016563vallate
valley124311603valley
valval12398863valval
valvar12388653valvar
villa85321233villa_
villae95615383villae
villas96117263villas
wall76236103wall__
wallaby1535073wallaby
walled104021293walled
wallet93327093wallet
wallie93216803wallie
wallop113310293wallop
wallow123913513wallow
walls85529383wall_s
wally114625093wall_y
waylay1535453waylay
zillahs1935383zillahs

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164736.42017557.0
3Display Results4734730.3601313.9
 (SQL Overall)1786914736.92025822.4
 
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.