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 “posters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

200 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
posters9392801(None) 
costers94128331costers
fosters104220101fosters
pasters94531731pasters
pesters93827091pesters
porters93722701porters
posers84223971pos_ers
poster84129171poster_
postern93615611postern
posterns102713721posterns
potters94024341potters
pouters94221871pouters
powters124015661powters
rosters73727541rosters
zosters163015411zosters
asters65631602_asters
basters94930302basters
bisters93922612bisters
boasters103915662boasters
boaters93419242boaters
bolsters103712452bolsters
bolters94017802bolters
boosters104013442boosters
busters94724132busters
casters94729902casters
coasters104317332coasters
coaters93525792coaters
colters93522442colters
cooters94525722cooters
copters113621282copters
coshers123618182coshers
costars94218012costars
coster84331292coster_
cotters94323442cotters
couters93827302couters
dosers75723632dos_ers
dossers84516232dossers
doters74423912do_ters
dotters83715972dotters
dusters84918362dusters
easters75125682easters
esters64627732_esters
festers104121392festers
footers104618332footers
foster94322222foster_
gasters85624292gasters
goiters84014442goiters
hoisters113513482hoisters
holsters113211942holsters
hooters104520472hooters
hosers95223962hos_ers
hosiers104212642hosiers
hostels103712312hostels
hostess103210242hostess
hostlers113310482hostlers
imposters13347342imposters
jesters144118192jesters
jolters143711992jolters
joshers174111592joshers
jostlers15357682jostlers
jotters143413802jotters
jousters153210422jousters
justers143815732justers
koshers144811802koshers
lasters75627692lasters
listers74026532listers
lobsters10268742lobsters
lofters103912902lofters
loiters74116612loiters
looters74419162looters
losers65123582los_ers
lotters73921062lotters
lusters73921442lusters
masters94628922masters
misters93927512misters
mobsters12359062mobsters
molters93816972molters
monsters103314552monsters
mooters93818622mooters
moshers124017842moshers
mossers94116192mossers
musters94522512musters
nesters74422792nesters
noshers103614332noshers
noters64021002no_ters
oaters65029792_oaters
osiers63412792_osiers
ostlers72911202_ostlers
otters64021512_otters
ousters74122792ousters
outers64230172_outers
oxters134813272_oxters
oysters103411692oysters
palters94021682palters
passers94717752passers
pastels95215182pastels
paster85734372paster_
pastern94415062pastern
pasterns104112622pasterns
pastes85233912paste_s
pastors94119002pastors
paters84935832p_aters
patters94825192patters
pelters93720312pelters
pensters103012122pensters
pester84827592pester_
peters86624592p_eters
petters93722362petters
pewters124113352pewters
piasters102912812piasters
pishers123815752pishers
pissers95014752pissers
pistes85325632piste_s
plasters103518132plasters
platers93924092platers
plotters104011552plotters
poetess938932poetess
pointers103013722pointers
poisers94214432poisers
pokers124617922po_kers
polders103617372polders
polers84225642po_lers
pollers93420022pollers
pollsters1137172pollsters
ponders103618842ponders
pontes83627852ponte_s
poofters1336922poofters
poolers94217422poolers
poppers103414862poppers
porkers134314932porkers
porter84224412porter_
poser75128772pos_er_
poses74642762pos_e_s
poseurs9378292poseurs
posher115018162posher_
posies84431432posie_s
posses85128802posse_s
possess9419122possess
possets94212772possets
postals93716372postals
posted93722492poste_d
posteen93512622posteen
posteens10309732posteens
posties93128812posties
postins93721202postins
postops11311712postops
posts75228782post__s
posture9313252posture
posturers1137052posturers
postures10313782postures
pothers123818622pothers
potter83926982potter_
pottery123011072pottery
potzers184010542potzers
poulters103911052poulters
pourers93513672pourers
pouter83923982pouter_
powders134111552powders
powers113822322po_wers
powter114116032powter_
praters94921652praters
presters103419002presters
prosers94219642pros_ers
prospers123012262prospers
punsters103310582punsters
punters93617042punters
pushers123814502pushers
putters94219192putters
rasters74629022rasters
resters74130402resters
roasters83615932roasters
roisters83615552roisters
roosters83514662roosters
rooters74522932rooters
roster64329082roster_
rotters74421392rotters
rousters84315682rousters
routers74822872routers
roysters113610532roysters
sisters73721592sisters
sorters74221132sorters
souters74422602souters
sporters103714062sporters
spotters104313382spotters
spouters104011162spouters
tasters74225642tasters
testers74124542testers
toasters83912722toasters
tooters73818772tooters
tossers74713502tossers
toters65026362to_ters
totters74618732totters
touters74018352touters
ulsters72711982ulsters
voters95017442vo_ters
wasters104026592wasters
westers105221962westers
xysters17307162xysters
zesters163517292zesters
zoster153715852zoster_

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076712003.06335152.1
3Display Results2002000.0762631.6
 (SQL Overall)1786912003.51250880.1
 
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.