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

255 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
peltries1031302(None) 
belfries1336982belfries
celeries10316312celeries
entries71523162_entries
gentries91315262gentries
helotries1269562helotries
paltrier1037532paltrier
paltriest1138602paltriest
pantries101817392pantries
pastries101517422pastries
pedlaries12108782pedlaries
pedleries1298782pedleries
peeries93623022pe_eries
pelerines11311842pelerines
pelorias10410592pelorias
penuries10311662penuries
perries93226602pe_rries
poetries10315582poetries
poultries1148452poultries
psaltries1185742psaltries
retries74129072re_tries
sentries81318052sentries
vestries11314052vestries
aeries64737783ae__ries
agentries1048233agentries
aperies9423203ape__ries
beladies11310423beladies
belfried1444203belfried
belies84631053bel__ies
bellies94023723bel_lies
beltlines1135963beltlines
berries94423553be_rries
bestrides1237913bestrides
calories102919563calories
centres93817123centr_es
centuries11311333centuries
claries93422203_claries
dearies83526273de_aries
decries103319803de_cries
decuries11312223decuries
deities82621923deit_ies
dellies83622213del_lies
deltoids1045483deltoids
derries83124623de_rries
descries11311923descries
destrier9311823destrier
destriers1038143destriers
deviltries1444133deviltries
dextrines1798313dextrines
dextrins16117823dextrins
eateries8324313_eateries
elegies81312903_elegies
emeries91620023_emeries
entires71517783_entires
entrees71813773_entrees
estrins7315853_estrins
eyries93816813_e_yries
fealties1139993fealt_ies
fellies104119743fel_lies
felonies11310993felonies
felonries1246203felonries
ferries103521083fe_rries
fewtrils1443203fewtrils
gantries91413793gantries
gentrices1258913gentrices
glories81915923_glories
hearties11315413hearties
helleries122611683helleries
henries102718283he_nries
herries104025073he_rries
jellies143816533jel_lies
jerries143817513je_rries
jetties143613123je_tties
kellies113516853kel_lies
kelpies13289903kel_pies
kerries113317913ke_rries
kilties113014143kilt_ies
lealties8310793lealt_ies
lefties10312073left_ies
lories64933043__lories
melodies11310123melodies
meltages1148243meltages
memories121214353memories
metres85121563me_tr_es
metrics11312363me_trics
nectaries1149813nectaries
nellies73418723nel_lies
oestrins8312673oestrins
palsies94420273pal_sies
paltrily1345413paltrily
paltriness1244993paltriness
panfries13149203panfries
panties94230933pant_ies
paries84742513p__aries
parries93925843p_arries
parties93230863part_ies
pasties94529813past_ies
patsies93919483p_atsies
patties93425143p_atties
peatier94017233peat_ier
peatiest103118813peat_iest
peavies122213403pe_avies
peccaries1548533peccaries
pectases122411193pectases
pectates122213953pectates
pectines121914683pectines
pectins112315233pect_ins
pectizes21229793pectizes
pedantries1345683pedantries
peddleries14104073peddleries
peerie83617893pe_erie_
pelages10714613pel_ages
pelagics1345553pelagics
pelerine10313013pelerine
peles75738083pel___es
pelisses1048483pelisses
pelites93821993pel_ites
pellitories1354843pellitories
peloria9310953pelori_a
pelorian1048883pelorian
peloric11310713pelori_c
pelorus939273pelor_us
peloruses1145873peloruses
peltasts1035703peltasts
peltate92013773peltate_
pelted94617763pelt__ed
pelter83321623pelt__er
peltered112510453peltered
peltering122011673peltering
pelters93720313pelt_ers
pelting102917273pelt_ing
peltless10267373peltless
peltry11288653peltr__y
pelts76128813pelt___s
pelves114514663pel__ves
pelvics14245643pel_vics
pelvis113610323pel_vi_s
pelvises1337273pelvises
penalties11139513penalt_ies
pennies94218813pe_nnies
pentanes10316083pentanes
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
peonies93620153pe_onies
peptics132610243pept_ics
peptides132610263peptides
peptids12239323pept_ids
peptizes21269853peptizes
peptones12311033peptones
peres76246643pe__r_es
perils84121853pe__rils
peris75537073pe__ri_s
perjuries1846493perjuries
perses85428063pe__rses
pertains102113423pertains
pessaries11108663pessaries
pestier94317403pest_ier
pestiest103018413pest_iest
pestles93217693pest_les
petites93820203pe_tites
petrales10312983pe_trales
petrel83111533pe_tr_el
petrels9279373pe_trels
petrifies14310363pe_trifies
petrify1536573pe_trify
petrols92913083pe_trols
petrous92714423pe_trous
pettier94213613pe_ttier
pettiest103113963pe_ttiest
pettles93916483pe_ttles
peytrals1355493peytrals
peytrel1264253peytr_el
peytrels1363373peytrels
philtres1396513philtr_es
phratries1447583phratries
pieties9419223piet_ies
pilgrims1344143pilgrims
pillories1189573pillories
pineries102419083pineries
pities83828083p_it_ies
platies93722543p_laties
plenaries11410383plenaries
plenties10314693plenties
plies74526513p_l__ies
plotties103111413plotties
polarise10513903polarise
polarises11514073polarises
polarizes20513023polarizes
policies122415663policies
polies84034583pol__ies
polities102722343polities
poperies12316793poperies
posties93128813post_ies
potpies113116173p_otpies
potsies93019483p_otsies
potteries11313593potteries
potties93723543p_otties
prairies10411453prairies
predries112714383predries
prelacies13310053prelacies
pretrims1238983pretrims
pretties10615133pretties
pries74339533p___ries
priories10312453priories
psalteries1276563psalteries
puggries12166383puggries
punties94520783punt_ies
putties94420023p_utties
realties8514853realt_ies
reburies10311143reburies
rectories11314653rectories
rectrices1338873rectrices
redries83721713re_dries
reentries9311763reentries
refries104419733re_fries
relies65036423rel__ies
restrikes1339413restrikes
restrives12310663restrives
reties65436193re_t_ies
retires74726213re_tires
retried84419153re_tried
retrims93612373re_trims
reveries112518513reveries
salaries8319593salaries
salties73725773salt_ies
saltires83112433saltires
sealeries9313133sealeries
sectaries11312243sectaries
selkies113513353sel_kies
series64540973se__ries
serries73925353se_rries
shelties111111383shelt_ies
smelteries1246163smelteries
spectres12268683spectr_es
speltzes1944003spelt_zes
sultrier837773sultrier
sultriest938653sultriest
sweltrier1242993sweltrier
sweltriest1343283sweltriest
tapestries1245403tapestries
tectrices1346253tectrices
tellies73820503tel_lies
terries73425633te_rries
tetris62816293te_tri_s
tries55742813___tries
veeries102916893ve_eries
velarizes2148643velarizes
velures1039093velur_es
veneries112815033veneries
voleries11313233voleries
wastries111212883wastries
wearies103020223we_aries
wellies103719073wel_lies
zealotries1944353zealotries

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.420425454.8
2DLD Change Limit1461622557.22020244.0
3Display Results2552550.1102318.2
 (SQL Overall)1786912557.75023056.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.