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

305 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
halvah1549983(None) 
halavah16447021halavah
hallah124115401hallah
halva115414431halva_
halvahs16417531halvahs
halvas124714171halvas
almah106917252_almah
chalah143511662chal_ah
challah15458322challah
galah95917642gal_ah
halakah17517962halakah
halal85623592hal_al
halalah13429392halalah
halavahs17415792halavahs
hallahs133912462hallahs
hallal94415562hallal
halma108219252halma_
halmas117017892halmas
halve114818922halv_e
halved134813902halved
halves124717092halves
hamzah23135562hamzah
valval12398862valval
valvar12388652valvar
wallah124011992wallah
aah616252963_a__ah
ala312463603_al_a_
alae45643753_al_ae
alan46844083_al_an
alar46340073_al_ar
alas46358123_al_as
alba68328333_alba_
albas75925393_albas
aleph10311393_aleph
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algal66518223_algal
algas65624933_algas
alias55834603_alias
aliyah12397493_aliyah
allay85620393_allay
alma66333023_alma_
almahs118611613_almahs
almas76629773_almas
almeh106214553_almeh
aloha8513623_aloha
alpha1049653_alpha
altar55520643_altar
alway116113923_alway
amah98927493_a_mah
arval86017013_arval
ava610139323_a_va_
ayah108022993_a_yah
balas76937213bal_as
ballad94315323ballad
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
blah98625063_bl_ah
calash11312433calash
calcar10312753calcar
caliph13311403caliph
calla74827073calla_
callan83619603callan
callas84526753callas
calpac123211063calpac
calvary1537183calvary
calve105919923calv_e
calved125215453calved
calves115119283calves
canvas113813333canvas
casbah1337903casbah
chalahs15289883chal_ahs
chaleh143711993chal_eh
challa114014193challa_
challahs16377563challahs
challas124414123challas
chaloth15298603chaloth
daledh1133743daledh
daleth1038633daleth
fallal93612693fallal
fava106820263fa_va_
favas115618593fa_vas
fellah124910773fellah
gala55635163gal_a_
galahs105512683gal_ahs
galas65731643gal_as
galax135314463gal_ax
galea64722943galea_
galeae74717453galeae
galeas74618513galeas
galosh1038573galosh
galyac1235973galyac
galyak1445333galyak
ganjah17145503ganjah
haaf106227733ha__af
haar77323493ha__ar
hadal95518123ha_dal
hadith13312063hadith
haemal113811643haemal
hah910655223h___ah
haha107821063ha_ha_
hahas117118443ha_has
haika125313793haika_
halacha15388023halacha
halakahs18426633halakahs
halakha17416593halakha
halakhah17384763halakhah
halala94715093halala
halalahs14367443halalahs
halalas104214083halalas
halals95018313halals
hale76052833hal__e
haled95335823hal_ed
haler85033523hal_er
halers94926913halers
haleru94212073haleru
hales85449843hal_es
halest94823273halest
half106238453hal__f
halfway1943763halfway
halid94424983hal_id
halide103417993halide
halids104016133halids
haling104229783haling
halite93624233halite
hall75741163hal__l
hallel93514093hallel
hallo85127553hal_lo
halloa94918123halloa
halloas104318463halloas
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
halloth134111253halloth
hallow124818323hallow
halls85633783hal_ls
hallux1637363hallux
hallway1636173hallway
halm95834973hal__m
halms105225213hal_ms
halo76437323hal__o
haloed104717603haloed
haloes94623863haloes
haloid104317763haloid
halon86124863hal_on
halons95720713halons
halos85230253hal_os
halt76056303hal__t
halted105019603halted
halter94420883halter
halts85230103hal_ts
halutz1868853halutz
halvers133311423halvers
halving143511543halving
halyard1476973halyard
hamal104623113ha_mal
hammal134512063hammal
hammam12419333hammam
hamza19139773hamza_
hamzahs24134373hamzahs
hamzas20119013hamzas
handax1749583handax
hangar104114513hangar
hansa85416783hansa_
hansas94616043hansas
hapax1739323ha_pax
harsh116418053ha_rsh
hartal9415473hartal
hash106936503ha__sh
hatch135719593ha_tch
hath105933913ha__th
haugh125114053ha_ugh
haunch14377343haunch
have106137073ha_v_e
haven114718533ha_ven
haver115124463ha_ver
haves116034873ha_ves
havoc1337183ha_voc
hazan173813613ha_zan
hazmat20312263hazmat
hazzan17236803hazzan
health124712143heal_th
heliac111010893heliac
helve115018093helv_e
helved134313703helved
helves124316063helves
hijrah1934283hijrah
hila76228353hil_a_
hilar85418143hil_ar
holla84918493holla_
hollas94616903hollas
hookah16488243hookah
hoorah124411113hoorah
horah117922053h_orah
houdah1335173houdah
howdah1634723howdah
hula74923753hul_a_
hulas84920883hul_as
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
hyla106716513hyl_a_
hylas114815903hyl_as
jalap143612473jal_ap
jarrah1636683jarrah
java147316643ja_va_
javas155915423ja_vas
kalam11315113kal_am
kalian10312163kalian
kaliph1537873kaliph
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
kasbah1535183kasbah
kava115819703ka_va_
kavas125919953ka_vas
lallan63414173lallan
larva8312483larva_
larvae938843larvae
larval948503larval
larvas9310233larvas
lava76725423la_va_
lavas85422223la_vas
lavash12597373la_vash
malar76424443mal_ar
maltha1137513maltha
matsah1138233matsah
matzah2035963matzah
mikvah18143473mikvah
mollah11319453mollah
mullah113710733mullah
nala46930393nal_a_
nalas55528363nal_as
naval85315833na_val
navar83912733na_var
nullah9388143nullah
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
palish114718273palish
palmar104113463palmar
palpal104112053palpal
pardah123412823pardah
pariah114320583pariah
pavan106518473pa_van
rajah155711423ra_jah
ralph1078743ral_ph
rayah116013503ra_yah
salaam8711013salaam
salad65321833sal_ad
salal55425703sal_al
saliva93110743saliva_
salivas10309603salivas
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
salvage1138193salvage
salve85022133salv_e
salved103916423salved
salver94617753salver
salves94221763salves
salvia93310753salvia
salvias10279933salvias
salvo84415643salv_o
salvor94711093salvor
salvos94613383salvos
selah8319613sel_ah
selva83014273selva_
selvas93812913selvas
shariah132210533shariah
shivah15488543shivah
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
sylva11268443sylva_
sylvae12236863sylvae
sylvan12257363sylvan
sylvas12288173sylvas
tala45938053tal_a_
talar56225383tal_ar
talas55935893tal_as
ulva75412693_ulva_
ulvas84511503_ulvas
valvate133710813valvate
valve114515933valv_e
valved136711043valved
valves124113783valves
volva11399003volva_
volvas12447993volvas
vulva11448803vulva_
vulvae12438033vulvae
vulval12417663vulval
vulvar12427963vulvar
vulvas12388843vulvas
walla85321033walla_
wallahs13409473wallahs
wallas95719393wallas
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.376475242.0
2DLD Change Limit1127163055.42020796.3
3Display Results3053050.0933279.6
 (SQL Overall)1786913055.88930343.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.