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

243 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
potterer10231026(None) 
patterer103112171patterer
pottered112311661pottered
potterers11218661potterers
putterer10209911putterer
totterer8217791totterer
batterer102713212batterer
bitterer10309772bitterer
cottered112511732cottered
dotterel945062dotterel
fetterer11207812fetterer
fosterer11239522fosterer
letterer8259222letterer
litterer82810172litterer
loiterer837082loiterer
mutterer10218912mutterer
palterer102411282palterer
pattered112714202pattered
patterers112410122patterers
pesterer102412712pesterer
pewterer13256312pewterer
ponderer112410192ponderer
portered112311542portered
posturer1038922posturer
pothered142311042pothered
potteen9319672potte_en
potter83926982pott__er
potteries11313592potteries
potters94024342potter_s
pottery123011072potter_y
pottier93516492pott_ier
poulterer1145422poulterer
powderer14245592powderer
puttered112611142puttered
putterers11238362putterers
rottener8216972rottener
sputterer11165262sputterer
titterer8268522titterer
tottered9208702tottered
totterers9186812totterers
utterer71910462_utterer
alterer72714003_alterer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
battener10369393battener
battered113315053battered
batterers113110713batterers
bettered113011843bettered
bittered112711833bittered
bolsterer1145483bolsterer
borderer1168103borderer
bothered142110393bothered
bottler94211883bott_ler
bottomer1245103bottomer
buttered112712623buttered
butterier1177453butterier
caterer92815943_caterer
chatterer14196843chatterer
clatterer11186993clatterer
coherer122912783co_herer
cottager11306813cottager
cotter84926673cott__er
cotters94323443cotter_s
cottier93814173cott_ier
coverer123113523co_verer
ditherer12187763ditherer
dodderer1144203dodderer
dotter74419343dott__er
dotterels1043903dotterels
dotters83715973dotter_s
dottier83910923dott_ier
dottrel834463dott_rel
enterer72015633_enterer
falterer11239863falterer
fattener11268113fattener
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
flatterer12187683flatterer
flutterer12185263flutterer
fostered122210453fostered
fosterers12238023fosterers
fritterer12234403fritterer
gatherer12147913gatherer
gettered10258613gettered
guttered10259163guttered
hosteler1137283hosteler
hotter94720083hott__er
hoverer13319823ho_verer
jittered16267223jittered
jitterier1644433jitterier
jotter134315633jott__er
jotters143413803jotter_s
latherer111310453latherer
lettered92910783lettered
letterers9228113letterers
littered92511383littered
litterers9228193litterers
lobsterer1144033lobsterer
loitered938183loitered
loiterers936263loiterers
lotter64025603lott__er
lotteries9311073lotteries
lotters73921063lotter_s
lottery10389833lotter_y
mattered112412903mattered
miterer92511333_miterer
mothered142310103mothered
motleyer1343263motleyer
mottler94410343mott_ler
muttered112610793muttered
mutterers11247373mutterers
nattered92011623nattered
offerer1335543_offerer
oftener1035923_oftener
orderer8127943_orderer
otter54423973_ott__er
otters64021513_otter_s
oysterer1136103oysterer
paltered113012493paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903p_aperer
parterre1036993parterre
pasturer1037523pasturer
pattee84323383patte_e_
pattened11299393pattened
patter84628263patt__er
pattern93712053patter_n
patterned1265743patterned
patterns10439943patterns
patters94825193patter_s
peltered112510453peltered
pepperer1145283pepperer
pestered112814973pestered
pesterers112510463pesterers
petered103314973p_etered
petter83924773pett__er
petters93722363petter_s
pettier94213613pett_ier
pewterers14216043pewterers
pilferer1344923pilferer
plasterer1178113plasterer
plotter94113663plott__er
plotters104011553plotter_s
plottier10327263plott_ier
pocketer16157373pocketer
poetiser1037313poetiser
poetizer1936813poetizer
poitrel936193poit_rel
pondered126411293pondered
ponderers12248453ponderers
poorer82613993po__orer
porter84224413port__er
porteress1137933porteress
porters93722703porter_s
portiere1038773portiere_
portieres1138213portieres
portlier1038373portlier
posteen93512623poste_en
poster84129173post__er
posterior1147833posterior
postern93615613poster_n
posterns102713723posterns
posters93928013poster_s
postteen1055693postte_en
posture9313253posture_
postured1139493postured
posturers1137053posturers
postures10313783postures
poteen83514263po_te_en
potheen12257893pothe_en
pother113818853po_t_her
potherb14358683pother_b
potherbs15387123potherbs
pothers123818623pother_s
potometer1349843potometer
pottage103310603pottage_
pottages112910453pottages
potted94624013pott__ed
potteens10256793potteens
pottering122612003pottering
potties93723543pott_ies
pottle84416103pott_le_
pottles93816983pott_les
potzer174411213po_t_zer
potzers184010543potzer_s
poulterers1244563poulterers
pourer84516043po__urer
pouter83923983pout__er
pouters94221873pouter_s
poutier93215323pout_ier
powdered15256893powdered
powderers15214793powderers
powered132911643po_wered
powter114116033powt__er
powters124015663powter_s
profferer1742933profferer
properer1259203properer
puckerer1645793puckerer
puttee85919723putte_e_
puttees93612913putte_es
putter83921443putt__er
putters94219193putter_s
puttier93314503putt_ier
rattener8238533rattener
roisterer946433roisterer
rotter64325463rott__er
rotters74421393rotter_s
scatterer11186293scatterer
shatterer12177203shatterer
smatterer11185813smatterer
smotherer1444633smotherer
soberer93110353so_berer
softener1145613softener
solderer947183solderer
sorcerer1036433sorcerer
spattered12187643spattered
splutterer12132743splutterer
spotter94514883spott__er
spotters104313383spotter_s
spottier10207313spott_ier
sputtered12166323sputtered
sputterers12174583sputterers
steerer73113633_steerer
stutterer9164913stutterer
tattered92011443tattered
tittered9239493tittered
titterers9236993titterers
torturer835493torturer
totter65021463tott__er
totters74618733totter_s
tottery10388483totter_y
twitterer1243303twitterer
uttered82712433_uttered
utterers8218653_utterers
waterer103314073_waterer
winterer112110443winterer
witherer14187953witherer
wonderer12249183wonderer
yattered12239533yattered

Search took 7 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 Limit1461622436.39022873.6
3Display Results2432430.0932612.9
 (SQL Overall)1786912436.90625874.7
 
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.