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

513 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
pastils9441617(None) 
pastels95215181pastels
pasties94529811pasties
pastil85018321pastil_
pastis84924321pasti_s
pistils93314301pistils
apostils1046772apostils
basils85717472bas_ils
bastile9313912bastile
bastiles10313352bastiles
distils83015802distils
hastily133010662hastily
instils7811452instils
mastics112614782mastics
nasties73520492nasties
nastily103011032nastily
pails75833062pa__ils
panties94230932panties
pantile93918482pantile
pantiles103617152pantiles
partials101911952partials
parties93230862parties
pascals11610012pascals
pasquils1943122pasquils
passels93913022passels
pastas85422872past_as
pastel85918712pastel_
pasters94531732pasters
pastes85233912past_es
pastie85525522pasti_e
pastier94320382pastier
pastiest103319542pastiest
pastille1038942pastille
pastilles1148702pastilles
pastime114611972pastime
pastimes123611902pastimes
pastina93914592pastina
pastinas103712152pastinas
pasting103826552pasting
pastises103616052pastises
pastitso1043622pastitso
pastors94119002pastors
pastries101517422pastries
pasts75936502past__s
patins87528782pa_tins
patios85221782pa_tios
patsies93919482patsies
patties93425142patties
pistil83915072pistil_
pistols93213982pistols
plastics122412332plastics
plastids11269212plastids
pontils9312212pontils
postals93716372postals
posties93128812posties
postins93721202postins
ramtils938412ramtils
spastics1237502spastics
tastily103311642tastily
abseils935973abseils
actins86321103_actins
ails45654713_a__ils
anils56326723_a_nils
antics84621453_antics
antis55033313_anti_s
anvils9219713_anvils
apostil947903apostil_
apsis75718293aps_i_s
argils75213623_argils
arils58732203_a_rils
artels66216233_artels
artily92814713_artily
asdics9439863_asdics
aspics104211563_aspics
aspis74618143_aspi_s
assails769093assails
assoils776663assoils
asters65631603_asters
astilbe945653_astilbe
astilbes1044733_astilbes
astir55517093_asti_r
astrals75515243_astrals
atilt54828473_a_tilt
attics84413283_attics
avails939693_avails
axils127217503_a_xils
bails75933523ba__ils
banties94324763banties
basics104915123bas_ics
basil75122273bas_il_
basins85722763bas_ins
basis75429863bas_i_s
basters94930303basters
bastes85330383bast_es
bastille1047993bastille
bastilles1147353bastilles
basting104227203basting
bastings114214693bastings
bastion9312473bastion
bastions10411693bastions
basts75936933bast__s
batiks1239373ba_tiks
battiks1337143battiks
bawties124214313bawties
beasties102514653beasties
bestirs9311133bestirs
blasties102113633blasties
brasils9410973bras_ils
bustics11810883bustics
camails11311753camails
cantals93919573cantals
cartels94618123cartels
caseins93115053caseins
casitas93312043casitas
cassias93514343cassias
cassis84818853cassi_s
casters94729903casters
castes85631863cast_es
casting104628343casting
castings113614053castings
castle84918963cast_le
castles94917733castles
castors94919443castors
casts77237793cast__s
casuals91410523casuals
cattails1038553cattails
catties94023053catties
cattily123210853cattily
caustics1237483caustics
cavils114014393ca_vils
clastics122811413clastics
dactyls1333913dactyls
dashis104414393dashi_s
dassies84418663dassies
dauties83315763dauties
dawties113312703dawties
dentils84115583dentils
distil73616433distil_
distill83011323distill
distills9319043distills
dossils8669773dossils
dustily113211523dustily
easels65914553eas_els
easies64126633eas_ies
easily9313023eas_ily
easters75125683easters
easting84924303easting
eastings93412953eastings
easts57530323east__s
elastics102710883elastics
elastins82111743elastins
fails85631483fa__ils
fantails1139693fantails
fascias1258413fascias
fastens105511753fastens
fasting114522833fasting
fastings124011943fastings
fasts86429683fast__s
fatties103018203fatties
fattily13379463fattily
fossils10379013fossils
fusils93912343fus_ils
fustics1279593fustics
fustily133111373fustily
gaskins123510773gaskins
gassily1137813gassily
gasters85624293gasters
gasting95022763gasting
gastrins9310123gastrins
gasts66628633gast__s
gustily113010903gustily
hails85231643ha__ils
hartals10313023hartals
hassels104311013hassels
hastens106214813hastens
hastes95727073hast_es
hastier103916623hastier
hastiest112916493hastiest
hasting114725193hasting
hostels103712313hostels
hostile10312553hostile
hostiles11312213hostiles
instals7611713instals
instil61111383instil_
instill789063instill
instills867353instills
isatins7310773isatins
jails125422943ja__ils
jasmins1637083jasmins
jassids1586143jassids
kails95525213ka__ils
laities7320343laities
lashins103915153lashins
lassies74420103lassies
lassis65216703lassi_s
lasters75627693lasters
lasting84725243lasting
lastings94214423lastings
lastly93310873last_ly
lasts57731263last__s
lattins74115483lattins
lentils73912973lentils
listels74212433listels
lustily103611243lustily
maftirs1236043maftirs
mails76037783ma__ils
maltols939403maltols
mantels94515043mantels
mantids103113623mantids
mantis83926033manti_s
martins93322063martins
mashies12318253mashies
masjids17175403masjids
massifs1237743massifs
masters94628923masters
mastic103119173masti_c
mastiff1538163mastiff
mastiffs1644233mastiffs
masting104325823masting
mastitis1039103mastitis
mastix152310513masti_x
mastixes1738253mastixes
mastoids1177873mastoids
masts77035763mast__s
matins84527783ma_tins
mattins93316143mattins
mistily122612343mistily
mustily123613633mustily
mystics14279103mystics
nails55730403na__ils
nasals63312463nas_als
nastic82915973nasti_c
nastier74115293nastier
nastiest83615953nastiest
nattily103610323nattily
nautili746113nautili
nautilus844073nautilus
nostrils848183nostrils
oasis56422553oas_i_s
oasts56529183oast__s
paction112713963paction
pactions122613503pactions
pacts95125803pact__s
paddies113715723paddies
padis86227143pa_di_s
paiks114719853pa__iks
pail66141833pa__il_
pains75138283pa__ins
pairs75325833pa__irs
palais8420423palai_s
palatals1037773palatals
palls74332563pa__lls
pals66951353pa___ls
palships1546213palships
palsies94420273palsies
palters94021683palters
paltrily1345413paltrily
pandies104224503pandies
pandits103914213pandits
panels84716523pa_nels
panfuls1237173panfuls
panics103815363pa_nics
pansies94521983pansies
pantie84326473panti_e
pantiled113111593pantiled
panting104025423panting
pantos85222743pant_os
pantries101817393pantries
pants76536923pant__s
papains11312363papains
pappies103214823pappies
parasails1147583parasails
parboils1237433parboils
parcels113712663parcels
paretics122312443paretics
paries84742513pa_ries
paris75145943pa_ri_s
parities10522973parities
parols84722613pa_rols
parotids112610413parotids
parrals94414573parrals
parrels94713493parrels
parries93925843parries
parsnips1245533parsnips
partans94418283partans
partial92616263partial
partible1238063partible
particle1239533particle
particles1339803particles
partied103516553partied
partier93520713partier
partiers103514243partiers
parting103527383parting
partings113513733partings
partita9310863partita
partitas10310253partitas
partite9317133partite
partly116315473part_ly
partons94620513partons
parts77743373part__s
parvis116114803parvi_s
pascal10812373pascal_
paschals1566473paschals
paseos88015813pas_eos
pases75346503pas__es
pashas115117063pas_has
pashes115828393pas_hes
pashing135120513pashing
pasquil1843923pasquil_
pass65239953pas___s
passel85117003passel_
passers94717753passers
passes86030473pas_ses
passible1237693passible
passim10410283passi_m
passing104318423passing
passings11409873passings
passion9310883passion
passions10310583passions
passive12239593passive
passives13228823passives
passus83610293pas_sus
past65959013past___
pasta76624533past__a
paste74932953past__e
pasted94426903past_ed
pastelist1149623pastelist
paster85734373past_er
pastern94415063pastern
pasterns104112623pasterns
pasteup1134983pasteup
pasteups1243493pasteups
pasticci1443823pasticci
pastiche1546933pastiche
pastiches1637453pastiches
pastiness112312353pastiness
pastitsio1143143pastitsio
pastitsos1142893pastitsos
pastless102411203pastless
pastness102510503pastness
pastor84817483past_or
pastorals1147953pastorals
pastorly1345783pastorly
pastry114913033past_ry
pasture9311463pasture
pastures10311963pastures
pasty105725053past__y
patens84820863pa_tens
paters84935833pa_ters
pates76047893pa_t_es
pathos115516693pa_thos
paths105521383pa_t_hs
patin76832853pa_ti_n
patina86022193pa_tina
patinas96318523pa_tinas
patine85328123pa_tine
patines95225763pa_tines
patio74426353pa_ti_o
patly105020583pa_t_ly
patois84319363pa_tois
patrols93513513patrols
pats66460853pa_t__s
pattens95414923pattens
patters94825193patters
pattie84020963patti_e
patting103722343patting
paulins9312613paulins
pavins114919663pa_vins
pavis106422733pa_vi_s
pawkily1934203pawkily
pawls105617663pa__wls
paynims1434973paynims
pectins112315233pectins
pencils113011773pencils
pensils92811593pensils
pentyls1236523pentyls
peptics132610243peptics
peptids12239323peptids
perils84121853p_erils
peskily1635083peskily
pesters93827093pesters
pestier94317403pestier
pestiest103018413pestiest
pestle83215843pest_le
pestles93217693pestles
pestos84719083pest_os
pests75933273pest__s
petals84719813p_etals
pettily1238173pettily
phasis114614923phas_i_s
phasmids16195183phasmids
photics142810483photics
phytins15317893phytins
phytols15276553phytols
piasters102912813piasters
piastres10249303piastres
pieties9419223pieties
pigsties1139783pigsties
pigtails1146033pigtails
pintails10310163pintails
pistes85325633pist_es
pistol83313333pistol_
pistole92414313pistole
pistoles102514723pistoles
pistons93016373pistons
pistous92714383pistous
pities83828083p_ities
plasmids13236553plasmids
plasmins12199413plasmins
plasters103518133plasters
plastic112815063plasti_c
plasticly1644763plasticly
plastid102112523plasti_d
plastisols1242353plastisols
platies93722543platies
poetics11312073poetics
pontil8315463pontil_
portals94015563portals
posies84431433pos_ies
posits85718713pos_its
postal84317533postal_
posters93928013posters
postie84123963posti_e
postin83521033posti_n
posting105622243posting
postings112912303postings
postops11311713postops
posts75228783post__s
potsies93019483potsies
potties93723543potties
prosties101421193prosties
protyls12298463protyls
psis68120343p_s_i_s
punties94520783punties
pupils10389913p_upils
pushily15247983pushily
pussies93615693pussies
pustule937683pustule
pustules1038443pustules
putties94420023putties
rails55937403ra__ils
ramtil8311023ramtil_
rascals959663rascals
rasters74629023rasters
ratals64219583ra_tals
ratels64518213ra_tels
ratios64922673ra_tios
rattails837133rattails
resails74616743resails
rustics9810733rustics
rustily103112993rustily
sails55738103__sails
salties73725773salties
saltily10310543saltily
santims9312603santims
santirs7312963santirs
santols73513323santols
sasins64923103sas_ins
sassies74719263sassies
sassily1038723sassily
satins64930483sa_tins
satis55633683sa_ti_s
soils55327983__soils
spails84817823spa__ils
spastic11310383spasti_c
sties55132983__sties
stile54931573__stile
stiles64328773__stiles
still54922083__still
stills64118573__stills
stilt54831983__stilt
stilts67915313__stilts
stirs55921623__stirs
tactics1149323tactics
tactile9310613tactile
tahsils1035053tahsils
tails55634193ta__ils
tartily103511573tartily
tassels74510853tassels
tassies74918933tassies
tasters74225643tasters
tastes64126423tast_es
tastier711817093tastier
tastiest83216633tastiest
tasting84624213tasting
tatties74120343tatties
tattily10409993tattily
testily102910803testily
testis64916713testi_s
tils45739613___tils
upstirs935293upstirs
vails85825933va__ils
vakils1337593va_kils
vassals1057953vassals
vastier103613203vastier
vastiest112713073vastiest
vastity1336203vastity
vastly12508723vast_ly
vasts86423773vast__s
vestals104612333vestals
wagtails1244443wagtails
wails86631483wa__ils
waspily1535513waspily
wassails1145953wassails
wasters104026593wasters
wastes96224883wast_es
wasting114422843wasting
wastrels1136203wastrels
wastries111212883wastries
wasts87433673wast__s
yautias1046333yautias
yeastily1444573yeastily
zestily19167563zestily

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.423422437.4
2DLD Change Limit1340275137.18618651.1
3Display Results5135130.2032527.1
 (SQL Overall)1786915137.81222873.9
 
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.