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

348 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
pantries10181739(None) 
gantries91413791gantries
panfries13149201panfries
panties94230931pant_ies
pastries101517421pastries
antres65021002_antr_es
banties94324762bant_ies
canaries10318942canaries
cantrips12318932cantrips
chantries14310292chantries
entries71523162_entries
gauntries1046042gauntries
gentries91315262gentries
paltrier1037532paltrier
paltriest1138602paltriest
pandies104224502pan_dies
panfried14134932panfried
pansies94521982pan_sies
pantie84326472pant_ie_
pantiles103617152pantiles
paries84742512pa__ries
parries93925842pa_rries
parties93230862part_ies
pasties94529812past_ies
patsies93919482pa_tsies
patties93425142pa_tties
pedantries1345682pedantries
peltries10313022peltries
penuries10311662penuries
pineries102419082pineries
poetries10315582poetries
psaltries1185742psaltries
punties94520782punt_ies
sentries81318052sentries
wastries111212882wastries
aeries64737783_a_eries
agentries1048233agentries
ambries111614553_ambries
anergies9310453_anergies
angaries9314393_angaries
angrier839023_angrier
angriest9310253_angriest
anomies93316993_anomies
antes56334323_ant__es
antics84621453_ant_ics
antired82316193_antired
antis55033313_ant_i_s
antre55224523_antr_e_
antrums969173_antrums
antsier7410773_antsier
antsiest8511463_antsiest
anurias7312253_anurias
apathies1339013apathies
aperies9423203_aperies
apiaries10312733apiaries
arteries8321483_arteries
attires72312953_attires
attrites8311563_attrites
attrits7310613_attrits
aunties73920073aunt_ies
bakeries14312193bakeries
bandies104124863ban_dies
banditries1345343banditries
banshies131110663banshies
batteries11615113batteries
bawdries14136843bawdries
bawties124214313bawt_ies
beaneries11310903beaneries
binaries10314183binaries
calories102919563calories
candies104125613can_dies
canities101519263canities
canneries11313083canneries
canonries1148413canonries
canopies12311853canopies
cantles94721413cant_les
cantraips13255273cantraips
cantraps12319113cantraps
cantrip112910043cantri_p
caries85147623ca__ries
carries94328013ca_rries
catteries11815523catteries
catties94023053ca_tties
cauteries11615393cauteries
centres93817123centr_es
centuries11311333centuries
chanties132615803chant_ies
contrives14311703contrives
countries11313613countries
dainties9312403daint_ies
dairies84217733da_iries
dandies94121443dan_dies
dataries9314033dataries
daubries1136743daubries
dauties83315763daut_ies
dawties113312703dawt_ies
deaneries10310833deaneries
eateries8324313eateries
entires71517783_entires
entrees71813773_entrees
errantries1044943errantries
factories14810113factories
faeries104118993fa_eries
fairies103516043fa_iries
fakeries1559833fakeries
fancies124018783fan_cies
fannies103415643fan_nies
fantails1139693fantails
fantasies1298853fantasies
fatties103018203fa_tties
fineries112416743fineries
flaneries1249563flaneries
gantlines1039333gantlines
gastrins9310123gastrins
gentrices1258913gentrices
granaries10159883granaries
hankies143617763han_kies
hantles104117513hant_les
harries103525493ha_rries
henries102718283hen_ries
infantries1344693infantries
japeries17311463japeries
kanteles1238123kanteles
kauries113613193ka_uries
laetriles944673laetriles
laities7320343lait_ies
laniaries9411223laniaries
latrias71913213la_trias
latrines8515013la_trines
laundries1045563laundries
mandrils1138493mandrils
mantes84430783mant__es
mantids103113623mant_ids
mantis83926033mant_i_s
mantises10317923mantises
mantles94820703mant_les
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantr_as
mantric11311353mantri_c
manures9313353manur_es
marries93825283ma_rries
martyries1446563martyries
masteries111018493masteries
matres84522233ma_tr_es
matrices12312083ma_trices
matrixes1738063ma_trixes
nancies93516843nan_cies
nannies73015203nan_nies
naperies10313903naperies
nasties73520493nast_ies
pacifies15311223pacifies
paddies113715723pa_ddies
padres95016983pa_dr_es
pageantries1452983pageantries
pagurids12144003pagurids
paintier1048793paint_ier
paintiest11310563paint_iest
palsies94420273pa_lsies
paltrily1345413paltrily
paltriness1244993paltriness
panaches15310293panaches
panbroils1343223panbroils
pancakes1637073pancakes
pancreas1235393pancreas
pandied113913443pan_died
pandits103914213pan_dits
pandores11312453pandores
panes76148693pan___es
pangenes112612823pangenes
pangrams1337153pangrams
panicles121010113panicles
panics103815363pan__ics
panier84425503pan__ier
paniers94717333pan__iers
panmixes1934913panmixes
pannes85522853pan__nes
pannier93613353pan_nier
panniers10488853pan_niers
panoches1548123panoches
panoplies1346003panoplies
panpipes1135173panpipes
pantalet10415903pantalet
pantalets1147673pantalets
pantdress1243363pantdress
panted95024823pant__ed
pantheism1645653pantheism
pantheist1449153pantheist
panther12611443pant_her
panthers13510783panthers
pantile93918483pant_ile
pantiled113111593pantiled
panting104025423pant_ing
pantofles1474863pantofles
pantomimes1644233pantomimes
pantos85222743pant__os
pantoums1236713pantoums
pantry115014103pantr__y
pantrymen1643273pantrymen
pants76536923pant___s
pantsuits1144083pantsuits
papacies1439483papacies
papeteries1446553papeteries
papistries1445193papistries
pappies103214833pa_ppies
pares77164483pa__r_es
parges94529543pa__rges
paris75145943pa__ri_s
parises94827183pa__rises
parities10522973parities
parles86334403pa__rles
parodies11313693parodies
parried103615723pa_rried
parrier93717653pa_rrier
parriers103612903pa_rriers
parses85534703pa__rses
partakes1449923partakes
parterres1148063parterres
partied103516553part_ied
partier93520713part_ier
partiers103514243part_iers
partridges1453053partridges
parures9512693parur_es
pastes85233913past__es
pastie85525523past_ie_
pastier94320383past_ier
pastiest103319553past_iest
pastils94416173past_ils
pastimes123611903pastimes
pastis84924323past_i_s
pastises103616053pastises
pastures10311963pastures
patches143320383pa_tches
pates76047893pa_t__es
patines95225763pa_tines
patins87528783pa_t_ins
patios85221783pa_t_ios
patois84319363pa_toi_s
patriates11311363pa_triates
patriot9314533pa_triot
patriots1038053pa_triots
patrols93513513pa_trols
patrons93818103pa_trons
pattie84020963pa_ttie_
peasantries1353413peasantries
peeries93623023p_eeries
pennies94218813pen_nies
pentanes10316083pentanes
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
perries93226603p_erries
phantasies1545483phantasies
phratries1447583phratries
piastres10249303piastr_es
pieties9419223piet_ies
pinkies133818263pin_kies
pinnies93318443pin_nies
pinstripes1443973pinstripes
pintails10310163pintails
pintles94118723pint_les
pintoes95117713pint_oes
pities83828083p_it_ies
planarias1147403planarias
planetaries1345943planetaries
plantains1147493plantains
platies93722543plat_ies
plenaries11410383plenaries
plenties10314693plent_ies
plotties103111413plotties
ponies84833463pon__ies
pontes83627853pont__es
pontils9312213pont_ils
poperies12316793poperies
posties93128813post_ies
potpies113116173p_otpies
potsies93019483p_otsies
potteries11313593potteries
potties93723543p_otties
poultries1148453poultries
prairies10411453prairies
predries112714383predries
pretrims1238983pretrims
pretties10615133pretties
pries74339533p___ries
printeries12410633printeries
priories10312453priories
psalteries1276563psalteries
puggries12166383puggries
punditries1343753punditries
punkies134216803pun_kies
putties94420023p_utties
randies84225663ran_dies
reentries9311763reentries
retries74129073_retries
salaries8319593salaries
salties73725773salt_ies
saltires83112433saltires
sangrias938373sangrias
sanies63031953san__ies
sanitaries1049913sanitaries
sanities81219773sanities
santerias9311843santerias
santims9312603sant_ims
santirs7312963sant_irs
satires72617573sa_tires
sauries72821623sa_uries
savories11311273savories
scanties103215423scant_ies
shanties113116593shant_ies
spandrils1244163spandrils
sundries9312023sundries
tanistries1047063tanistries
tanneries9310423tanneries
tansies74521243tan_sies
tantivies1247103tantivies
tantras73112093tantr_as
tantric939593tantri_c
tantrism1048373tantrism
tantrisms1146323tantrisms
tantrums1045113tantrums
tarries73324263ta_rries
tatties74120343ta_tties
tawdries12136083tawdries
tenantries1045673tenantries
tries55742813___tries
truantries1044023truantries
unties64326923_unt_ies
untried82615853_untried
untrims938613_untrims
vagaries12310293vagaries
vanities111414493vanities
vanitories1346913vanitories
vantages12119023vantages
varies94330873va__ries
veneries112815033veneries
vestries11314053vestries
vineries112716043vineries
wantages12109023wantages
wasteries121115343wasteries
wastrie101210303wastrie_
wineries112316533wineries
wintrier1136873wintrier
wintriest1238153wintriest
xanthines1966723xanthines
xanthins1846943xanthins
yantras10259003yantr_as
zanies153219673zan__ies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623487.25020160.3
3Display Results3483480.1402485.7
 (SQL Overall)1786913487.81322871.0
 
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.