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

502 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
fallal9361269(None) 
fallals103310191fallals
hallal94415561hallal
algal66518212_algal
allay85620392_allay
allyl85310542_allyl
ballad94315322ballad
calla74827072calla_
callan83619602callan
callas84526752callas
facial113615632facial
faecal11359812faecal
falbala1235872falbala
fall75535312fa_l_l
fallacy1536432fallacy
fallen93813372fallen
faller94621232faller
fallow124713852fallow
falls85727652fall_s
farfal123410182farfal
fatal84819372fa_tal
faucal11339962faucal
faunal94711592faunal
fella84918652fella_
fellah124910772fellah
fellas95116962fellas
filial93013252filial
fullam1138362fullam
halal85623592ha_lal
hallah124115402hallah
hallel93514092hallel
lallan63414172lallan
paleal84716672paleal
pallial92911252pallial
palpal104112052palpal
salal55425702sa_lal
tallol63612222tallol
valval12398862valval
walla85321032walla_
wallah124011992wallah
wallas95719392wallas
aal39058673_a__al
afloat9315153afloat
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
alkali10127553_alkali
alkyl12518043_alkyl
all36148233_a_l_l
allays94313743_allays
allee54932123_allee
allele64514563_allele
alley85721673_alley
allheal1044553_allheal
allod64418373_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
argal65023383_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
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
carnal83919203carnal
carpal103716253carpal
casual81112863casual
caudal91611483caudal
causal81413203causal
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
challa114014193challa_
challah15458323challah
challas124414123challas
collar83816173collar
cullay113910173cullay
daedal849083daedal
dalles74222063dalles
dally95324743dall_y
diallel845683diallel
dollar74110983dollar
earlap837183earlap
fable105824753fabl_e
fabled124216383fabled
fabler116115813fabler
fables114921673fables
fabliau1244903fabliau
fabular12288693fabular
facia103218463facia_
faciae112913413faciae
facials123310743facials
facias113415803facias
factual1246723factual
facula112912233facula_
faculae123210353faculae
facular122810443facular
faena85014203faena_
faenas94412763faenas
fail74840243fa__il
failed105421603failed
faille93414743faille
failles102914123failles
fails85631483fail_s
falafel1383903falafel
falbalas1345473falbalas
falcate12311613falcate
falces115216003falces
falcon11310293falcon
falderal12104803falderal
fallalery1542173fallalery
fallaway1743903fallaway
fallback1944553fallback
fallers103917993fallers
fallible1355363fallible
fallibly1644393fallibly
falling113621583falling
falloff1245953falloff
fallout10313503fallout
fallows133713973fallows
false84818123fa_lse
falsely1336013falsely
falser93912413falser
falsie93513853falsie
falter94519053falter
falx147120783fa_l_x
familial1366073familial
fanga96119623fanga_
fangas105017193fangas
fantail10310233fantail
farad95720673fa_rad
fardel104712593fardel
farfals13268503farfals
farfel124310433farfel
farl76338553fa__rl
farle86929243farl_e
farles96025783farles
farls85731113farl_s
fascial1258303fascial
fatally1339893fatally
fatly115716803fatl_y
fatwa1168063fatwa_
fatwas1249053fatwas
faucals12326563faucals
faucial1257323faucial
fauld95214493faul_d
faulds10438963faulds
fault85428313faul_t
faults94513553faults
faulty12429363faulty
fauna84816513fauna_
faunae95210373faunae
faunas94013633faunas
fava106820263fa_va_
favas115618593fa_vas
favela1237033favela_
favelas1337023favelas
favella1336173favella_
favellas1446163favellas
feal713940423f__eal
fecal105119213f_ecal
fecial114714623fecial
fell76833073f_el_l
fellable13179133fellable
fellahs13428393fellahs
fellate10313433fellate
felled103720303felled
feller94419553feller
felloe93513923felloe
fellow123712743fellow
fells85327383fell_s
felly114922803fell_y
feral85424653f_eral
ferial94621253ferial
festal94213563festal
fetal85623373f_etal
fetial95716193fetial
feudal1037683feudal
fila74729133f_ila_
filar84819293f_ilar
fill75540193f_il_l
fillable13179563fillable
fille84327403fill_e
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
fillip11268953fillip
fillo84319783fill_o
fillos94415073fillos
fills84632373fill_s
filly114424903fill_y
final83922033f_inal
finial92814183finial
fiscal1139333fiscal
flab96628353f__lab
flag87427083f__lag
flail85316183f_lail
flak116026173f__lak
flam96333293f__lam
flan76134183f__lan
flap96128703f__lap
flat77147823f__lat
flaw106326643f__law
flax147325633f__lax
flay106332803f__lay
flea75628493f_lea_
fleam106017283f_leam
fleas86423663f_leas
float85928573f_loat
floral94313813floral
foal76630923f__oal
focal104917673f_ocal
foetal9311883foetal
folia83618933folia_
foliar93210973foliar
folles93820473folles
follis93113903follis
follow124010353follow
folly115022603foll_y
fontal9313143fontal
formal113215203formal
foveal1237703foveal
fractal1237623fractal
frill84917563fril_l
frugal1036393frugal
fugal95613033f_ugal
fulfil1246423fulfil
fulham1435303fulham
full75229153f_ul_l
fullams1236553fullams
fulled103820653fulled
fuller94220383fuller
fulls84623523full_s
fully114820863full_y
fulmar1137253fulmar
fungal10388733fungal
gala55635163ga_la_
galah95917623ga_lah
galas65731643ga_las
galax135314463ga_lax
galea64722933galea_
galeae74717453galeae
galeas74618503galeas
gall56335993ga_l_l
gallant83517113gallant
gallate83417123gallate
galled84622853galled
gallet73630853gallet
galley104215453galley
gallfly1433523gallfly
gallic9411633gallic
gallon73715813gallon
gallop93311383gallop
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galyac1235973galyac
galyak1445333galyak
gavial10310083gavial
gayal9312713ga_yal
glial66715433_glial
hadal95518123ha_dal
haemal113811643haemal
halala94715093halala
halalah13429383halalah
halalas104214083halalas
halals95018313halals
hall75741163ha_l_l
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hall_o
halloa94918123halloa
halloas104318463halloas
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halls85633783hall_s
hallucal1343483hallucal
hallux1637363hallux
hallway1636173hallway
halma108219253halma_
halmas117017893halmas
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
hamal104623103ha_mal
hammal134512063hammal
hartal9415473hartal
holla84918493holla_
hollas94616903hollas
ileal56118083_ileal
ilial55317843_ilial
jacal14313703ja_cal
jackal1937613jackal
jalap143612473ja_lap
kalam11315113ka_lam
kalian10312163kalian
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
labial84714343labial
laical8312323laical
lall45531313la_l_l
lalland83810173lalland
lallans74113533lallans
lalled74218753lalled
lalls55324133lall_s
larval948503larval
leal46043273__leal
maill74420793mail_l
malar76424443ma_lar
mall64639363ma_l_l
mallard10310273mallard
malled94626103malled
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
pallid93915273pallid
pallor8313673pallor
palls74332563pall_s
pally105727123pall_y
palmar104113463palmar
paludal1035683paludal
papal95820673pa_pal
parlay113713993parlay
parral85517533parral
pascal10812373pascal
pausal81511963pausal
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
sulcal8311273sulcal
tabla73318363tabla_
tablas83716163tablas
tala45938053ta_la_
talar56225383ta_lar
talas55935893ta_las
tall47240213ta_l_l
tallage82712073tallage
taller63721963taller
tallis63319963tallis
tallit63422733tallit
tallols73311353tallols
tallow93714203tallow
talls55133433tall_s
tally84526863tall_y
tamal73522613ta_mal
tarnal63716503tarnal
tarsal63315273tarsal
telial65815363telial
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.1401276364.3
2DLD Change Limit1127165024.94022817.0
3Display Results5025020.1563217.9
 (SQL Overall)1786915025.23634127.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.