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

167 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
pestered112814971pestered
pesterer102412711pesterer
festered122512112festered
peltered112510452peltered
pester84827592pester__
pesterers112510462pesterers
pesters93827092pester_s
petered103314972pe_tered
pewterer13256312pewterer
sesterce1047112sesterce
westered122511872westered
yestereve1543132yestereve
absterge1154083absterge
austere7312993auster_e
austerer838383austerer
bestrew1248003best_rew
bettered113011843bettered
bistered112913333bistered
centered112513523centered
deserve11108703des_erve
deterge9118463de_terge
entered82718883_entered
enterer72015633_enterer
entree61817883_ent_ree
esteem838813_este_em
ester54727713_ester__
esterase849483_esterase
esters64627733_ester_s
eterne6311723_e_terne
externe1438573_externe
fester94723513fester__
festers104121393fester_s
fettered12259493fettered
fetterer11207813fetterer
fostered122210453fostered
fosterer11239523fosterer
gesture839243gestur_e
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
gettered10258613gettered
jester134319153jester__
jesters144118193jester_s
kedgeree1444383kedgeree
kestrel1137113kest_rel
leistered1037043leistered
lettered92910783lettered
letterer8259223letterer
lustered92510603lustered
mastered112614003mastered
mestee84523883mest__ee
mestees94617753meste_es
metered103514013me_tered
mustered112511503mustered
nester64124183nester__
nesters74422793nester_s
neutered937423neutered
oystered1236923oystered
oysterer1136103oysterer
paltered113012493paltered
palterer102411283palterer
parterre1036993parterre
paster85734373paster__
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastored1139973pastored
pasture9311463pastur_e
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
pattered112714203pattered
patterer103112173patterer
pedigree1244883pedigree
peered93819493pe__ered
peerie83617893pe__erie
peewee11311963pe__ewee
pelter83321623pelter__
pelters93720313pelter_s
penster92811953penster__
pensters103012123penster_s
pentene9313793pente_ne
pentenes10315633pentenes
peppered1236133peppered
pepperer1145283pepperer
perter84422283perter__
perverse1336103perverse
pestering122315663pestering
pesthole1347553pesthole
pestier94317403pest_ier
pestle83215843pest__le
pestled102711453pest_led
pestles93217693pest_les
peter74427593pe_ter__
peters86624593pe_ter_s
petrel83111533pe_t_rel
petter83924773petter__
petters93722363petter_s
pewter114013673pewter__
pewterers14216043pewterers
pewters124113353pewter_s
peytrel1264253peyt_rel
pistareen1143993pistareen
plastered1288903plastered
plasterer1178113plasterer
portered112311543portered
posteen93512623poste_en
poster84129173poster__
postern93615613poster_n
posterns102713723posterns
posters93928013poster_s
posture9313253postur_e
postured1139493postured
posturer1038923posturer
postures10313783postures
pottered112311663pottered
potterer102310263potterer
preserve13108803pres_erve
prester93519623prester__
presterna1145263presterna
presters103419003prester_s
prestore104217353prestor_e
prestored125111673prestored
prestores114716083prestores
protegee1156963protegee
puttered112611143puttered
putterer10209913putterer
referee101615753re_feree
reserve101011203res_erve
rester63832433rester__
resters74130403rester_s
restore75822983restor_e
restored96417193restored
restorer84813723restorer
restores85222993restores
retiree75019083re_tiree
sesterces1147873sesterces
sistered92612803sistered
stere55328543__ster_e
stereo65317913__stereo
steres63929533__steres
teetered9258303teetered
tentered96412103tentered
tesserae844793tesserae
testee64323303test__ee
testees74215913teste_es
tester64227153tester__
testers74124543tester_s
vestee94319153vest__ee
vestees103513173veste_es
vesture10310373vestur_e
vestured1237463vestured
vestures11311043vestures
wasterie111211583wasterie
weltered12238433weltered
wester94222893wester__
westerly1445553westerly
western102911103wester_n
westerner1244963westerner
westerns11328963westerns
westers105221963wester_s
yester93417983yester__
yestereves1642473yestereves
yestern10338643yester_n
yestreen1144603yestreen
zester153617793zester__
zesters163517293zester_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 Filter1786911461620.436409841.7
2DLD Change Limit1461621677.26620115.9
3Display Results1671670.0602783.3
 (SQL Overall)1786911677.76223021.3
 
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.