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

160 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
potteries1131359(None) 
lotteries9311071lotteries
batteries11615112batteries
booteries11312772booteries
butteries11711762butteries
catteries11815522catteries
coteries10422702co_teries
poetries10315582poet_ries
poperies12316792po_peries
pottered112311662potter_ed
potterer102310262potter_er
potterers11218662potterers
pottering122612002pottering
potters94024342potter__s
potties93723542pott__ies
arteries8321483_arteries
batterie10711533batterie_
bobberies12107893bobberies
boiseries11411043boiseries
botcheries1746053botcheries
bottomries1443083bottomries
boweries13312293bo_weries
butleries11710073butleries
butterier1177453butterier
butteriest1276883butteriest
cauteries11615393cauteries
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
coterie9417403co_terie_
cottered112511733cotter_ed
cotterless1244023cotterless
cotters94323443cotter__s
cutleries1179213cutleries
dodgeries1246593dodgeries
doggeries1246673doggeries
dotterel945063dotter_el
dotterels1043903dotterels
dotters83715973dotter__s
doweries12411933do_weries
eateries8324313_eateries
flatteries1347413flatteries
fooleries1248743fooleries
fopperies1666013fopperies
forgeries13310003forgeries
hatterias1258743hatterias
hosieries1249213hosieries
hostelries1345423hostelries
hotties103016963hott__ies
jitterier1644433jitterier
jitteriest1744553jitteriest
jobberies20115423jobberies
joineries1648103joineries
jotters143413803jotter__s
lotters73921063lotter__s
masteries111018493masteries
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873mo_peries
mysteries141211193mysteries
niteries8318383_niteries
notaries8314933no_taries
orreries8310123_orreries
otters64021513_otter__s
outcries10313573_outcries
pantries101817393pant_ries
papeteries1446553papeteries
parterres1148053parterres
pastries101517423past_ries
pattered112714203patter_ed
patterer103112173patter_er
patterers112410123patterers
pattering122314423pattering
patterned1265743patterned
patterns10439943patter_ns
patters94825193patter__s
patties93425143patt__ies
pedleries1298783pedleries
peeries93623023p__eeries
peltries10313023pelt_ries
petters93722363petter__s
piggeries13107893piggeries
pineries102419083p_ineries
plotters104011553plotter__s
plotties103111413plott__ies
poesies93217403po__esies
poetesses1137233poetesses
polytenies1547113polytenies
porterages1345973porterages
portered112311543porter_ed
porteress1137933porteress
portering122012303portering
porters93722703porter__s
portieres1138213portier_es
posterior1147833posterior
posteriors1256813posteriors
posterities1369033posterities
posterity1448693posterity
posterns102713723poster_ns
posters93928013poster__s
posties93128813post__ies
postures10313783postur_es
potbellies1443393potbellies
potences12710693po_tences
potencies1369303potencies
potherbs15387123pother_bs
pothered142311043pother_ed
pothering151911283pothering
pothers123818623pother__s
potpies113116173po_t_pies
potsies93019483po_t_sies
pottages112910453pott_ages
potteen9319673potte__en
potteens10256793potte_ens
potter83926983potter___
pottery123011073potter__y
pottier93516493pott__ier
pottiest102815973pott__iest
pottles93816983pott__les
potzers184010543potzer__s
poultries1148453poultries
pouters94221873pouter__s
poverties1439513po_verties
powters124015663powter__s
preterites12411793preterites
preterits11410963preterits
printeries12410633printeries
pruderies1247873pruderies
psalteries1276563psalteries
pterins9812993p__terins
pufferies1745203pufferies
putrefies1444663putrefies
puttees93612913putte__es
puttered112611143putter_ed
putterer10209913putter_er
putterers11238363putterers
puttering122611643puttering
putters94219193putter__s
putties94420023putt__ies
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
roperies10315763ro_peries
roseries8317313ro_series
rotaries8315693ro_taries
rotters74421393rotter__s
sorceries1149933sorceries
spooferies1543703spooferies
spookeries1654293spookeries
spotters104313383spotter__s
toggeries1146213toggeries
tottered9208703totter_ed
totterer8217793totter_er
totterers9186813totterers
tottering10229613tottering
totters74618733totter__s
voleries11313233vo_leries
votaries11312013vo_taries
wasteries121115343wasteries

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.436409841.7
2DLD Change Limit1486411606.39323250.6
3Display Results1601600.0762105.3
 (SQL Overall)1786911606.90525878.5
 
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.