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

168 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
potterers1121866(None) 
patterers112410121patterers
potterer102310261potterer_
putterers11238361putterers
totterers9186811totterers
batterers113110712batterers
dotterels1043902dotterels
fetterers12267042fetterers
fosterers12238022fosterers
letterers9228112letterers
litterers9228192litterers
loiterers936262loiterers
mutterers11247372mutterers
palterers11249532palterers
patterer103112172patterer_
pesterers112510452pesterers
pewterers14216042pewterers
ponderers12248452ponderers
porteress1137932porteress
posturers1137052posturers
potteens10256792potte_ens
pottered112311662pottere_d
potteries11313592potteries
potters94024342pott__ers
poulterers1244562poulterers
powderers15214792powderers
putterer10209912putterer_
sputterers12174582sputterers
titterers9236992titterers
totterer8217792totterer_
utterers8218652_utterers
alterers82512493_alterers
banterers112410003banterers
barterers11269633barterers
batteners11238163batteners
batterer102713213batterer_
bitterer10309773bitterer_
bolsterers1244683bolsterers
borderers1276333borderers
bottlers103810013bott_lers
bottomers1344353bottomers
caterers102814403_caterers
chatterers15205463chatterers
clatterers12155423clatterers
coherers132310733co_herers
cottagers12305383cottagers
cottered112511733cottere_d
cotterless1244023cotterless
cotters94323443cott__ers
cottiers10399153cott_iers
coverers132712123co_verers
ditherers13196683ditherers
dodderers1243803dodderers
dotterel945063dottere_l
dotters83715973dott__ers
dottrels963493dott_rels
enterers82214153_enterers
falterers12238033falterers
fatteners12236873fatteners
fetterer11207813fetterer_
filterers12206973filterers
flatterers13175913flatterers
flutterers13184593flutterers
fosterer11239523fosterer_
fritterers13203393fritterers
gatherers13156883gatherers
hostelers1246633hostelers
hoverers14289023ho_verers
jotters143413803jott__ers
latherers12158853latherers
letterer8259223letterer_
litterer82810173litterer_
lobsterers1243483lobsterers
loiterer837083loiterer_
lotteries9311073lotteries
lotters73921063lott__ers
miterers10219683_miterers
mottlers10388183mott_lers
mutterer10218913mutterer_
offerers1434933_offerers
orderers9116563_orderers
otters64021513_ott__ers
oysterers1245573oysterers
palterer102411273palterer_
pamperers15236863pamperers
panderers12229153panderers
paperers122410453p_aperers
parterres1148053parterres
pasturers1136393pasturers
pattered112714203pattere_d
patterns10439943patter_ns
patters94825193patt__ers
pepperers1244903pepperers
pesterer102412703pesterer_
petters93722363pett__ers
pewterer13256313pewterer_
pilferers1444583pilferers
plasterers1286123plasterers
plotters104011553plott__ers
pocketers17196493pocketers
poetisers1145303poetisers
poetizers2045103poetizers
poitrels1035243poit_rels
ponderer112410193ponderer_
portered112311543portere_d
porters93722703port__ers
portieres1138213portiere_s
portress1038323port_ress
posteens10309733poste_ens
posteriors1256813posteriors
posterns102713723poster_ns
posters93928013post__ers
postteens1144373postte_ens
posturer1038923posturer_
postures10313783posture_s
poteens92910883po_te_ens
potheens13266483pothe_ens
potherbs15387123pother_bs
pothered142311043pothere_d
pothers123818623po_t_hers
potometers1449063potometers
pottages112910453pottage_s
potteen9319673potte_e_n
potter83926983pott__er_
pottering122612003pottering
pottery123011073pott__ery
pottier93516493pott_ier_
potties93723543pott_ie_s
pottiness1179703pottiness
pottles93816983pott_le_s
potzers184010543po_t_zers
poulterer1145423poulterer_
pourers93513673po__urers
pouters94221873pout__ers
powderer14245593powderer_
powters124015663powt__ers
profferers1842423profferers
puckerers1744513puckerers
puttees93612913putte_e_s
puttered112611143puttere_d
putters94219193putt__ers
puttiers10288013putt_iers
ratteners9237263ratteners
roisterers1045113roisterers
rottener8216973rottener_
rotters74421393rott__ers
scatterers12205043scatterers
shatterers13185723shatterers
smatterers12174873smatterers
smotherers1543813smotherers
softeners1245133softeners
solderers1066533solderers
sorcerers1145323sorcerers
splutterers13142163splutterers
spotters104313383spott__ers
sputterer11165263sputterer_
steerers82511353_steerers
stutterers10164303stutterers
titterer8268523titterer_
torturers944343torturers
tottered9208703tottere_d
totters74618733tott__ers
twitterers1342673twitterers
utterer71910463_utterer_
waterers112312783_waterers
winterers12209723winterers
witherers15146843witherers
wonderers13217933wonderers

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411686.22023897.3
3Display Results1681680.0802100.0
 (SQL Overall)1786911686.72026590.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.