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

359 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
wallah12401199(None) 
hallah124115401hallah
walla85321031walla_
wallahs13409471wallahs
wallas95719391wallas
allay85620392_allay
almah106917252_almah
ballad94315322ballad
calla74827072calla_
callan83619602callan
callas84526752callas
challah15458322challah
fallal93612692fallal
fellah124910772fellah
galah95917632ga_lah
halalah13429392halalah
hallahs133912462hallahs
hallal94415562hallal
halvah15499832halvah
lallan63414172lallan
mollah11319452mollah
mullah113710732mullah
nullah9388142nullah
wall76236102wall__
wallaby1535072wallaby
walled104021292walled
wallet93327092wallet
wallie93216802wallie
wallop113310292wallop
wallow123913512wallow
walls85529382wall_s
wally114625092wall_y
waylay1535452waylay
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
chalah143511663chalah
challa114014193challa_
challahs16377563challahs
challas124414123challas
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
halakah17517963halakah
halal85623593ha_lal
halala94715093halala
halalahs14367443halalahs
halalas104214083halalas
halals95018313halals
halavah16447023halavah
hall75741163hall__
hallel93514093hallel
hallo85127553hall_o
halloa94918123halloa
halloas104318463halloas
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
halloth134111253halloth
hallow124818323hallow
halls85633783hall_s
hallux1637363hallux
hallway1636173hallway
halma108219253halma_
halmas117017893halmas
halva115414433halva_
halvahs16417533halvahs
halvas124714173halvas
hamzah23135563hamzah
holla84918493holla_
hollas94616903hollas
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
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
swallow13355753swallow
tabla73318363tabla_
tablas83716163tablas
tala45938053ta_la_
talar56225383ta_lar
talas55935893ta_las
tall47240213tall__
tallage82712073tallage
taller63721963taller
tallis63319963tallis
tallish103313583tallish
tallit63422733tallit
tallith102913063tallith
tallol63612223tallol
tallow93714203tallow
talls55133433tall_s
tally84526863tall_y
tallyho1343043tallyho
vallate103016563vallate
valley124311603valley
valval12398863valval
valvar12388653valvar
villa85321233villa_
villae95615383villae
villas96117263villas
wadmal1237283wadmal
wail75238823wail__
wailed104823593wailed
wailer93720323wailer
wails86631483wail_s
wale74546433wa_l_e
waled94330993wa_led
waler84229263wa_ler
walers94824463walers
wales86142833wa_les
walies95324523walies
waling104525303waling
walk115625613wa_l_k
walked145313783walked
walker133913993walker
walks126218503wa_lks
walkup1534193walkup
walkway2043373walkway
wallaroo1144613wallaroo
wallets103914833wallets
walleye1336243walleye
wallies103320743wallies
walling113520973walling
wallops123410413wallops
wallows133613533wallows
walnut939433walnut
walrus956433walrus
waltz17615473wa_ltz
waly105830903wa_l_y
wangan10311223wangan
wanly115118023wanl_y
warmth1477933warmth
warpath1545203warpath
warsaw1236193warsaw
wash106033813wa__sh
watap102111673wa_tap
watch135617063wa_tch
waugh125411683wa_ugh
waul76927313waul__
wauled104713963wauled
wauls86120553waul_s
wawl105321943wawl__
wawled133811703wawled
wawls115416473wawl_s
waylaid1445093waylaid
waylays1634673waylays
wealth12379223wealth
welch134411493w_elch
well75832043well__
welled103820213welled
wellie92814913wellie
wells85426193well_s
welly114620013well_y
welsh113110363w_elsh
whidah1634803whidah
whydah1942953whydah
will75737513will__
willed104722453willed
willer94021063willer
willet95124833willet
willie94116453willie
willow12369693willow
wills84528963will_s
willy115321913will_y
zillahs1935383zillahs

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 Limit1127163594.82623356.0
3Display Results3593590.1103263.6
 (SQL Overall)1786913595.31233639.1
 
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.