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

354 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
fallals10331019(None) 
fallal93612691fallal_
allays94313742_allays
allyls9437272_allyls
ballads104212912ballads
callans94518472callans
callas84526752calla_s
facials123310742facials
falbala1235872falbala
falbalas1345472falbalas
fallacy1536432fallacy
fallers103917992fallers
fallows133713972fallows
falls85727652fa_l_ls
farfals13268502farfals
faucals12326562faucals
fellahs13428392fellahs
fellas95116962fella_s
fullams1236552fullams
halals95018312ha_lals
hallahs133912462hallahs
hallal94415562hallal_
hallels103310132hallels
lallans74113532lallans
salals65120082sa_lals
tallols73311362tallols
wallahs13409472wallahs
wallas95719392walla_s
aals49941143_a__als
alans55636173_a_lans
alas46358123_a_la_s
albas75925393_alba_s
aldols7109713_aldols
alfas87219043_alfa_s
algal66518223_algal_
algas65624933_alga_s
alias55834603_alia_s
alkali10127563_alkali
alkalis11148793_alkalis
alkyls13465723_alkyls
allay85620393_alla_y
allees64521483_allees
allele64514563_allele
alleles73812033_alleles
alleys95113303_alleys
allheals1143913_allheals
allies63827673_allies
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
alls46740923_a_l_ls
allyl85310543_allyl_
almahs118611613_almahs
almas76629773_alma_s
altars64518153_altars
always12409133_always
anlas55626933_anla_s
annals66415923_annals
appals104812943_appals
argals75517713_argals
atlas55821583_atla_s
atlatls744773_atlatls
baals76122703ba__als
balas76937213ba_la_s
ballad94315323balla_d
ballade104012563ballade
ballades114211643ballades
ballast9313993ballast
ballasts1037933ballasts
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballons93916963ballons
ballots94116033ballots
balls76236413ba_l_ls
balsams11579013balsams
balsas86417523balsa_s
cabals104020153ca_bals
calcars11312653calcars
calla74827073calla__
callable12310753callable
callaloo1044903callaloo
callaloos1144223callaloos
callan83619603calla_n
callant94121223callant
callants104112143callants
callees94117783callees
callers94221963callers
callets93821703callets
callous93516603callous
calls75634733ca_l_ls
callus85317073call_us
calpacs133110343calpacs
canals84421673ca_nals
cantals93919573cantals
carpals113414633carpals
casuals91410523casuals
causals91411183causals
cellars93713693cellars
challahs16377563challahs
challas124414123challa_s
collars93816573collars
cullays12347703cullays
dalles74222063dall_es
dallies84023193dallies
dollars83311023dollars
earlaps936393earlaps
fablers124812613fablers
fables114921673fabl_es
facial113615633facial_
facias113415803facia_s
faecal11359813faecal_
faenas94412763faena_s
faille93414743fail_le
failles102914133failles
fails85631483fa__ils
falafels1453113falafels
falcate12311623falcate
falces115216003fa_lces
falcons1239123falcons
falderals13104043falderals
fall75535313fa_l_l_
fallacies1446833fallacies
fallalery1542173fallalery
fallaway1743903fallaway
fallaways1843163fallaways
fallback1944553fallback
fallbacks2044353fallbacks
fallen93813373fall_en
faller94621233fall_er
fallfish1744463fallfish
fallible1355363fallible
fallibly1644393fallibly
falling113621583falling
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallouts1137883fallouts
fallow124713853fall_ow
falsely1336013falsely
falsies103515013falsies
falters103916473falters
fangas105017193fanga_s
fantails1139693fantails
farads104713273fa_rads
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farles96025783farl_es
farls85731113fa__rls
fatal84819373fa_tal_
fatally1339893fatally
fatless103212203fatless
fatwas1249053fatwa_s
faucal11339963faucal_
faulds10438963faul_ds
faults94513553faul_ts
faunal94711593faunal_
faunas94013633fauna_s
favas115618593fa_va_s
favelas1337023favela_s
favellas1446163favella_s
fecials123510333fecials
fella84918653fella__
fellable13179133fellable
fellah124910773fella_h
fellate10313433fellate
fellates11312753fellates
fellers104117543fellers
fellies104119743fellies
felloes104114383felloes
fellows134212433fellows
fells85327383f_el_ls
ferals94216643f_erals
fetials103711743fetials
filial93013253filial_
fillable13179573fillable
fillers104320213fillers
filles94224523fill_es
fillets103414753fillets
fillies103420253fillies
fillips12298133fillips
fillos94415083fill_os
fills84632373f_il_ls
finals94316163f_inals
finials103210153finials
fiscals1238003fiscals
flabs105818643f__labs
flags95321283f__lags
flails94313003f_lails
flams105125013f__lams
flans85327973f__lans
flaps105621383f__laps
flats86429743f__lats
flaws115920343f__laws
flays116321053f__lays
fleams115011943f_leams
fleas86423663f_lea_s
floats96816253f_loats
florals104210063florals
foals85721693f__oals
folles93820473foll_es
follies103618943follies
follis93113903foll_is
follows13409923follows
formals123312893formals
fractals1346133fractals
frills94414223fril_ls
fulfils1345723fulfils
fulhams1543983fulhams
fullam1138363fulla_m
fullers103817373fullers
fulls84623523f_ul_ls
fulmars1246423fulmars
fungals11276783fungals
galahs105512683ga_lahs
galas65731643ga_la_s
galeas74618513galea_s
gallant83517113gallant
gallants93310373gallants
gallate83417133gallate
gallates92815533gallates
galleass935053galleass
gallets83517403gallets
galleys11369713galleys
gallfly1433523gallfly
galliass935423galliass
gallies84122713gallies
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323ga_l_ls
gallus74313203gall_us
galyacs1335273galyacs
galyaks1534623galyaks
gavials1136603gavials
gayals1039513ga_yals
halal85623593ha_lal_
halala94715093ha_lala
halalahs14367443halalahs
halalas104214083halalas
hallah124115403halla_h
hallel93514093hallel_
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hall_os
hallows134417393hallows
halls85633783ha_l_ls
hallways1745423hallways
halmas117017893halma_s
halvahs16417533halvahs
halvas124714173halva_s
hamals114816823ha_mals
hammals14409223hammals
hartals10313023hartals
hollas94616903holla_s
jacals1539873ja_cals
jackals2036893jackals
jalaps15299183ja_laps
kalams12310603ka_lams
kalians11310183kalians
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
labials9299873labials
lallan63414173lalla_n
lalland83810183lalland
lallands9338573lallands
lalls55324133la_l_ls
maills84215283mail_ls
malars85020683ma_lars
mallard10310273mallard
mallards1138323mallards
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
mallows123714323mallows
malls76233433ma_l_ls
maltols939403maltols
mammals10389273mammals
manuals9311213manuals
mollahs12328283mollahs
mullahs12388733mullahs
mullas84215933mulla_s
nalas55528363na_la_s
narwals1036983narwals
nasals63312463na_sals
nullahs10316993nullahs
ollas54218283_olla_s
paellas9411413paella_s
palais8420423pa_lais
palatals1037773palatals
paleal84716673paleal_
pallets93919303pallets
pallial92911253pallial_
pallors9314363pallors
palls74332563pa_l_ls
palpal104112053palpal_
parlays123910453parlays
parrals94414573parrals
pascals11610013pascals
pillars9313493pillars
radials83614643radials
raglans82410133raglans
rallies73823343rallies
rallyes10348553rallyes
rascals959663rascals
ratals64219583ra_tals
sabals84618863sa_bals
sacrals93311793sacrals
salaams997703salaams
salads75316963sa_lads
salal55425703sa_lal_
sallets73719653sallets
sallies73227813sallies
sallows103915553sallows
salols64017873sa_lols
salpas85116923salpa_s
salsas65316133salsa_s
sambals115213483sambals
sandals82715203sandals
tablas83716163tabla_s
talars66021683ta_lars
talas55935893ta_la_s
tallage82712073tallage
tallages92312003tallages
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallol_
tallows103313743tallows
talls55133433ta_l_ls
tamals84116633ta_mals
tarsals72512603tarsals
vallate103016563vallate
valleys13407483valleys
valval12398863valval_
vandals113211663vandals
vassals1057953vassals
villas96117263villa_s
wadmals1335513wadmals
walla85321033walla__
wallaby1535073wallaby
wallah124011993walla_h
wallets103914833wallets
wallies103320743wallies
wallops123410413wallops
wallows133613533wallows
walls85529383wa_l_ls
waylays1634673waylays
zillahs1935383zillahs

Search took 9 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 Filter1786911340270.513348325.5
2DLD Change Limit1340273547.33018284.7
3Display Results3543540.2031743.8
 (SQL Overall)1786913548.04622208.7
 
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.