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

522 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
hallal9441556(None) 
fallal93612691fallal
halal85623591ha_lal
hallah124115401hallah
hallel93514091hallel
algal66518222_algal
allay85620392_allay
allyl85310542_allyl
ballad94315322ballad
calla74827072calla_
callan83619602callan
callas84526752callas
challa114014192challa_
challah15458322challah
challas124414122challas
fallals103310192fallals
hadal95518122ha_dal
haemal113811642haemal
halala94715092halala
halalah13429392halalah
halalas104214082halalas
halals95018312halals
hall75741162ha_l_l
hallahs133912462hallahs
hallels103310132hallels
hallo85127552hall_o
halloa94918122halloa
halloas104318462halloas
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallow124818322hallow
halls85633782hall_s
hallucal1343482hallucal
hallux1637362hallux
hallway1636172hallway
halma108219252halma_
halmas117017892halmas
halva115414432halva_
halvah15499832halvah
halvas124714172halvas
hamal104623112ha_mal
hammal134512062hammal
hartal9415472hartal
holla84918492holla_
hollas94616902hollas
lallan63414172lallan
paleal84716672paleal
pallial92911252pallial
palpal104112052palpal
salal55425702sa_lal
tallol63612222tallol
valval12398862valval
walla85321032walla_
wallah124011992wallah
wallas95719392wallas
aal39058673_a__al
ahull84010313ahul_l
ala312463603_a_la_
alae45643753_a_lae
alan46844083_a_lan
alar46340073_a_lar
alas46358123_a_las
alba68328333_alba_
albas75925393_albas
aldol61212333_aldol
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algas65624933_algas
alias55834603_alias
alkali10127563_alkali
alkyl12518043_alkyl
all36148233_a_l_l
allays94313743_allays
allee54932123_allee
allele64514563_allele
alley85721673_alley
allheal1044553_allheal
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
alls46740923_all_s
ally76935643_all_y
allyls9437273_allyls
alma66333023_alma_
almah106917253_almah
almas76629773_almas
altar55520643_altar
alula5317093_alula_
alulae6312743_alulae
alular6311353_alular
alway116113923_alway
anal48037523_a_nal
anlas55626933_anlas
annal56520763_annal
appal95315223_appal
areal55928733_areal
argal65023393_argal
artal55525473_artal
arval86017013_arval
atlas55821583_atlas
atlatl637873_atlatl
aural54428963_aural
axal116520493_a_xal
axial124515193_axial
baal67033113ba__al
balas76937213ba_las
ball66043323ba_l_l
ballade104012563ballade
ballads104212913ballads
ballast9313993ballast
balled94926893balled
baller83825203baller
ballet84733973ballet
ballon84117493ballon
ballot84624093ballot
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
balneal936573balneal
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banal75925993ba_nal
barbal104016663barbal
basal75722283ba_sal
bharal1138893bha_ral
bulla74620563bulla_
bullae83416163bullae
cabal95222153ca_bal
caecal103713733caecal
calcar10312753calcar
call66838673ca_l_l
callable12310753callable
callaloo1044903callaloo
callans94518473callans
callant94121223callant
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
callow114714663callow
calls75634733call_s
callus85317073callus
calpac123211063calpac
canal75428043ca_nal
cantal84122033cantal
carnal83919213carnal
carpal103716253carpal
casual81112863casual
caudal91611483caudal
causal81413203causal
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
chaetal1238283chaetal
chalah143511663cha_lah
chalazal2243873chalazal
challahs16377563challahs
challie124012853challie
challis124613463challis
challot123613263challot
chally144314293chall_y
chasmal14158213chasmal
cholla113911023cholla_
chollas123811353chollas
collar83816173collar
cullay113910173cullay
daedal849083daedal
dalles74222063dalles
dally95324743dall_y
diallel845683diallel
dollar74110983dollar
earlap837183earlap
facial113615633facial
faecal11359813faecal
falbala1235873falbala
fall75535313fa_l_l
fallacy1536433fallacy
fallen93813373fallen
faller94621233faller
fallow124713853fallow
falls85727653fall_s
farfal123410183farfal
fatal84819373fa_tal
faucal11339963faucal
faunal94711593faunal
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
filial93013253filial
fullam1138363fullam
gala55635163ga_la_
galah95917643ga_lah
galas65731643ga_las
galax135314463ga_lax
galea64722943galea_
galeae74717453galeae
galeas74618513galeas
gall56335993ga_l_l
gallant83517113gallant
gallate83417133gallate
galled84622863galled
gallet73630853gallet
galley104215453galley
gallfly1433523gallfly
gallic9411643gallic
gallon73715813gallon
gallop93311383gallop
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galyac1235973galyac
galyak1445333galyak
gavial10310083gavial
gayal9312713ga_yal
gharial1137343gharial
glial66715433_glial
haaf106227733ha__af
haar77323493ha__ar
haha107821063ha_ha_
hahas117118443ha_has
haika125313793haika_
hail74839063ha__il
hailed104122743hailed
hailer94720343hailer
hails85231643hail_s
halakah17517963halakah
halalahs14367443halalahs
halavah16447023halavah
hale76052833ha_l_e
haled95335823ha_led
haler85033523ha_ler
halers94926913halers
haleru94212073haleru
hales85449843ha_les
halest94823273halest
half106238453ha_l_f
halfway1943763halfway
halid94424983ha_lid
halide103417993halide
halids104016133halids
haling104229783haling
halite93624233halite
halliard12125963halliard
hallmark1744213hallmark
halloaed121510153halloaed
halloed113314913halloed
halloes104021523halloes
halloos103716743halloos
halloth134111253halloth
hallows134417393hallows
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
halvahs16417533halvahs
halve114818923ha_lve
halved134813903halved
halves124717093halves
halyard1476973halyard
hamals114816823hamals
hamaul114210873hamaul
hamlet113722793hamlet
hammals14409223hammals
hammam12419333hammam
hamular1236973hamular
hamza19139773hamza_
hamzah23135563hamzah
hamzas20119013hamzas
handax1749583handax
hangar104114513hangar
hangul1049213hangul
hansa85416783hansa_
hansas94616043hansas
hansel95214373hansel
haole84820083haol_e
haoles94919803haoles
hapax1739323ha_pax
haply135915063hapl_y
harl75740003ha__rl
harlot94422803harlot
harls85634503harl_s
hartals10313023hartals
haslet93222713haslet
hassel95614213hassel
hatful12108743hatful
haul75530453ha__ul
haulage1136913haulage
hauled104415213hauled
hauler95015123hauler
haulm104415413haul_m
haulms11558503haulms
haulmy14455553haulmy
hauls86123733haul_s
hawala12368913hawala
hawalas13348353hawalas
haylage1436443haylage
hazan173813613ha_zan
hazel176414813ha_zel
hazmat20312263hazmat
hazzan17236803hazzan
heal75645693h__eal
heliac111010893heliac
helical12311153helical
hell75637893h_el_l
hellcat12410173hellcat
helled104024703helled
heller93322513heller
hello86522983hell_o
hellos95321683hellos
hells85032043hell_s
hemal104419803h_emal
herbal112513493herbal
hiatal9310203hiatal
hiemal11339503hiemal
hila76228353h_ila_
hilar85418143h_ilar
hill76439493h_il_l
hilled104022223hilled
hiller94421633hiller
hillo84721653hill_o
hilloa94713033hilloa
hilloas104413553hilloas
hillos94618893hillos
hills85431353hill_s
hilly114422163hill_y
holdall1145473holdall
hollaed11359853hollaed
holland11349473holland
holler93520613holler
hollo84822163holl_o
holloa94914823holloa
holloas103814943holloas
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
holly114824433holl_y
horal86328683h_oral
hula74923753h_ula_
hulas84920883h_ulas
hull75428783h_ul_l
hulled103920013hulled
huller93919103huller
hullo84417453hull_o
hulloa95011183hulloa
hulloas103911913hulloas
hulloo94511733hulloo
hullos94916293hullos
hulls84923563hull_s
hyetal1236543hyetal
hyla106716513h_yla_
hylas114815903h_ylas
hymnal1434913hymnal
hyphal1736413hyphal
ileal56118083_ileal
ilial55317843_ilial
jacal14313703ja_cal
jackal1937613jackal
jalap143612473ja_lap
kalam11315113ka_lam
kalian10312163kalian
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
labial84714343labial
laical8312323laical
lall45531313la_l_l
lalland83810183lalland
lallans74113533lallans
lalled74218753lalled
lalls55324133lall_s
larval948503larval
leal46043273__leal
maill74420793mail_l
malar76424443ma_lar
mall64639373ma_l_l
mallard10310273mallard
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
mallow114014743mallow
malls76233433mall_s
maltol8310843maltol
mammal95112753mammal
manual8313463manual
molal75120343_molal
mollah11319453mollah
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
nala46930393na_la_
nalas55528363na_las
narial6317953narial
narwal938943narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
nullah9388143nullah
olla44821173_olla_
ollas54218283_ollas
paella8410913paella_
paellas9411413paellas
palatal9310153palatal
palea75028663palea_
paleae84820293paleae
pall65039343pa_l_l
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallid93915283pallid
pallor8313673pallor
palls74332563pall_s
pally105727123pall_y
palmar104113463palmar
paludal1035683paludal
papal95820673pa_pal
parlay113713993parlay
parral85517533parral
pascal10812373pascal
pausal81511963pausal
phalli1148263phall_i
phallic1447293phallic
phallus1236063phallus
phaseal1245673phaseal
pillar8314023pillar
plagal948573plagal
pulpal10408453pulpal
racial83419243racial
radial74020393radial
raglan73711503raglan
rally84725903rall_y
rallye95110163rallye
ramal74622243ra_mal
rascal8511123rascal
ratal55025113ra_tal
sabal75422483sa_bal
sacral83414413sacral
salaam8711013salaam
salad65321833sa_lad
salals65120083salals
sall44544683sa_l_l
sallet63734543sallet
sallow94315753sallow
sally85129713sall_y
salol55222143sa_lol
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
sambal105215183sambal
sandal73317283sandal
shall85024053sha_l_l
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shellac1236693shellac
shillala11143793shillala
sulcal8311273sulcal
tabla73318363tabla_
tablas83716163tablas
tala45938053ta_la_
talar56225383ta_lar
talas55935893ta_las
tall47240213ta_l_l
tallage82712073tallage
taller63721963taller
tallis63319963tallis
tallit63422733tallit
tallols73311363tallols
tallow93714203tallow
talls55133433tall_s
tally84526863tall_y
tamal73522623ta_mal
tarnal63716503tarnal
tarsal63315273tarsal
telial65815363telial
thalli958923thall_i
thallic1246553thallic
thallus1035603thallus
vagal94613633va_gal
vallate103016563vallate
valley124311603valley
valvar12388653valvar
vandal103713833vandal
vasal85516293va_sal
vassal979243vassal
villa85321233villa_
villae95615383villae
villas96117263villas
vulval12417663vulval
wadmal1237283wadmal
wall76236103wa_l_l
wallaby1535073wallaby
wallahs13409473wallahs
walled104021293walled
wallet93327093wallet
wallie93216803wallie
wallop113310293wallop
wallow123913513wallow
walls85529383wall_s
wally114625093wall_y
waylay1535453waylay
zillah1836563zillah

Search took 6 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.373479064.3
2DLD Change Limit1127165225.42320784.8
3Display Results5225220.1733017.3
 (SQL Overall)1786915225.96929936.5
 
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.