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

329 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
paellas941141(None) 
paella8410911paella_
patellas1039101patellas
callas84526752ca_llas
canellas10310562canellas
favellas1446162favellas
fellas95116962_fellas
lamellas1098162lamellas
palls74332562pa_ll_s
patella938952patella_
patellae1047622patellae
patellar1046862patellar
payolas12148972payolas
psyllas1244882psyllas
stellas72813042stellas
wallas95719392wa_llas
abelias93213563abelias
akelas10311193_akelas
alas46358123_a__las
albas75925393_a_lbas
alfas87219043_a_lfas
algas65624933_a_lgas
alias55834603_a_lias
allay85620393_a_llay
allays94313743_a_llays
alls46740923_a_ll_s
almas76629773_a_lmas
anlas55626933_a_nlas
apollos946793apollos
areolas71013863areolas
atlas55821583_a_tlas
avellan1037293avellan
axillas14278963axillas
balas76937213ba__las
ballad94315323ba_llad
ballads104212913ba_llads
ballast9313993ba_llast
balls76236413ba_ll_s
balsas86417523ba_lsas
barillas10310193barillas
belgas9311713_belgas
belles85325993_belles
bells76432163_bell_s
cabalas113516003cabalas
cadelles1139973cadelles
caeomas1138403caeomas
calesas9411833calesas
calla74827073ca_lla_
callan83619603ca_llan
callans94518473ca_llans
calls75634733ca_ll_s
callus85317073ca_llus
camelias12510303camelias
camellias1365093camellias
canella9310793canella_
canolas9313993canolas
canulas9312853canulas
cavallas1366843cavallas
cella75420313_cella_
cellae84915933_cellae
cellar84514983_cellar
cellars93713693_cellars
cellos84517803_cellos
cells75428063_cell_s
challas124414123challas
chelas113817203che_las
chollas123811353chollas
dahlias1135723dahlias
dalles74222063da_lles
dells66630943_dell_s
deltas74414823_deltas
duellos845763duellos
dwells10417713dwell_s
ells46431353__ell_s
faenas94412763fae_nas
failles102914133failles
fallal93612693fa_llal
fallals103310193fa_llals
falls85727653fa_ll_s
favelas1337023favelas
favella1336173favella_
fella84918653_fella_
fellah124910773_fellah
fellahs13428393_fellahs
fells85327383_fell_s
gabelles11278933gabelles
galas65731643ga__las
galeas74618513ga_leas
galenas83310343galenas
galls64729323ga_ll_s
gallus74313203ga_llus
gazelles18266563gazelles
halalas104214083halalas
halals95018313ha_lals
hallah124115403ha_llah
hallahs133912463ha_llahs
hallal94415563ha_llal
halloas104318463halloas
hallos95425103ha_llos
halls85633783ha_ll_s
halmas117017893ha_lmas
halvas124714173ha_lvas
hawalas13348353hawalas
hellos95321683_hellos
hells85032043_hell_s
hollas94616903_hollas
jellos134714283_jellos
jells125522163_jell_s
kabalas133911063kabalas
kalpas124112943ka_lpas
kamalas13339123kamalas
knells10439253knell_s
kvells13346613kvell_s
labella988943labella_
lallan63414173la_llan
lallans74113533la_llans
lalls55324133la_ll_s
lamella988613lamella_
lamellae10117033lamellae
lamellar1096493lamellar
latillas847363latillas
maculas113114023maculas
maills84215283maill_s
malls76233433ma_ll_s
manilas93915873manilas
manillas102611163manillas
masalas9312053masalas
maxillas17227703maxillas
mells75031333_mell_s
mullas84215933_mullas
nacelles1048393nacelles
nalas55528363na__las
niellos736143niellos
nigellas944723nigellas
novellas1176343novellas
obelias9279033obelias
ocellar936533ocellar
ocellus935983ocellus
ollas54218283__ollas
pablums1345123pablums
pabular11259473pabular
pacas96029403pa__cas
pachas135017143pa_chas
paddles113515643paddles
padles95221123pa_dles
paean77222723pae__an
paeans85118263pae_ans
paeons83915523pae_ons
paesan85114093pae_san
paesans93312693paesans
pagodas11367553pagodas
paillard1146263paillard
paillards1244983paillards
paillasse1142693paillasse
pails75833063pa_il_s
paisas84317493pa_isas
pajamas18278153pajamas
pakehas1635313pakehas
pakoras1337473pakoras
palais8420423pa_lais
palapas11311493palapas
palea75028663pa_lea_
paleae84820293pa_leae
paleal84716673pa_leal
palely11311933palel_y
pales75753803pa__les
palets85122313pa_lets
paleways1645833paleways
pall65039343pa_ll__
palled94625163pa_lled
pallet84232653pa_llet
pallets93919303pallets
pallia83015593pa_llia
pallial92911253pallial
pallid93915283pa_llid
pallor8313673pa_llor
pallors9314363pallors
pally105727123pa_ll_y
palmar104113463pa_lmar
palms94921753pa__lms
palpal104112053pa_lpal
palps94719563pa__lps
palpus104210283pa_lpus
pals66951353pa__l_s
pampas124913993pa_mpas
panadas103312213panadas
panamas113112763panamas
panatellas1253213panatellas
pandas95521963pa_ndas
paneless102611763paneless
panelled1138963panelled
panels84716523panel_s
panetelas1153803panetelas
panetellas1252793panetellas
pangas99921103pa_ngas
papas94927493pa__pas
papayas1437273papayas
papilla11127913papilla_
papillae12137023papillae
papillar1296713papillar
papula103011113papula_
papulae11249353papulae
papular11299763papular
papules112411573papules
parallax1745643parallax
paras76143043pa__ras
pareiras1038183pareiras
parkas125018023pa_rkas
parlay113713993pa_rlay
parlays123910453parlays
parles86334403pa_rles
parleys125212373parleys
parlors9312913parlors
parlous9414293parlous
paroles95025883paroles
parols84722613parol_s
parrals94414573parrals
paruras9310533paruras
pascals11610013pascals
pashas115117063pa_shas
pastas85422873pa_stas
patacas11311003patacas
patellate1147483patellate
patinas96318523patinas
paulins9312613paulins
pavlovas1642423pavlovas
pawls105617663pa_wl_s
payload1336403payload
payloads1445293payloads
payola11208113payola_
peals75235493p_eal_s
pearlash1344133pearlash
pearls84715393pearl_s
peas65755063p_e__as
pedals94316033p_edals
pedlar93311273p_edlar
pedlars103210213p_edlars
peelers93615593peelers
peels75226423p_eel_s
peles75738083p_e_les
pelfs105016293p_e_lfs
pellet83326553p_ellet
pellets94014783p_ellets
pelotas9410723p_elotas
peltast9310513p_eltast
pelts76128813p_e_lts
pelves114514663p_elves
pelvis113610323p_elvis
pepla9312863p_epla_
peplos101211543p_eplos
peplus10138343p_eplus
perillas10310823perillas
petals84719813p_etals
phallus1236063phallus
phellem1435833phellem
phellems1544543phellems
phyllos1535583phyllos
pietas84516503pie_tas
pillar8314023p_illar
pillars9313493p_illars
pills74130973p_ill_s
pleas75627033p__leas
pleuras937413pleuras
pneumas1145103pneumas
polkas1239103p_olkas
polls74627723p_oll_s
predellas1245283predellas
prelaw1139103pre_law
prelims1139823prelims
preload1049813preload
preloads1157513preloads
preplan1149953preplan
preplans1249613preplans
prills84015613prill_s
prunellas1143683prunellas
psylla1133953psylla_
pueblos1134843pueblos
pulls74425053p_ull_s
pyaemias1545063pyaemias
pyemias1436803pyemias
pyrolas1239863pyrolas
qabalas18289503qabalas
queleas1636723queleas
quells15359703quell_s
radulas839583radulas
ramblas112710263ramblas
ranulas7311773ranulas
rubellas10136123rubellas
salals65120083sa_lals
salpas85116923sa_lpas
salsas65316133sa_lsas
scillas9310473scillas
selles64426983_selles
sells55134433_sell_s
selvas93812913_selvas
sheilas1059403sheilas
shellac1236693shellac
shellacs1345573shellacs
shells94319523shell_s
sheltas10279673sheltas
skells105013783skell_s
smells83914743smell_s
snells64614203snell_s
spalls84217343spa_ll_s
spatulas1045473spatulas
spells84617683spell_s
stella63612973stella_
stellar72610423stellar
swells93913983swell_s
tablas83716163ta_blas
taels56822073tae_l_s
taenias7311283taenias
tailles72516473tailles
talas55935893ta__las
tallis63319963ta_llis
talls55133433ta_ll_s
tells55828943_tell_s
tellys9348843_tellys
teslas64212173_teslas
trellis739873trellis
upwells12244303upwell_s
vanillas11228123vanillas
villas96117263_villas
walla85321033wa_lla_
wallah124011993wa_llah
wallahs13409473wa_llahs
walls85529383wa_ll_s
wells85426193_well_s
yells85821943_yell_s

Search took 8 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.406440125.6
2DLD Change Limit1340273296.72019944.5
3Display Results3293290.1063103.8
 (SQL Overall)1786913297.23224708.4
 
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.