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

456 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
poetess93893(None) 
poetless1038721poetless
hostess103210242hostess
peeress939502peeress
peters86624592p_eters
poetesses1137232poetesses
poetics11312072poetics
poetise9314042poetise
poetises10313952poetises
poets76024442poet__s
poleless1089872poleless
pontes83627852ponte_s
popeless1288472popeless
porters93722702porters
portless10310642portless
portress1038322portress
possess9419122possess
posters93928012posters
poteens92910882poteens
potters94024342potters
pouters94221872pouters
powters124015662powters
precess11310862precess
pretest9517632pretest
pretests10310012pretests
toeless72612392toeless
woeness1020211542woeness
ageless8310343ageless
aretes64425353arete_s
aweless1038723aweless
betels84515063_betels
boatels93510233boatels
boaters93419243boaters
boites84322703boite_s
boletes9316063bolete_s
bolters94017803bolters
boltless10338283boltless
boneless10310213boneless
bootees94114473bootees
bootless103410983bootless
botels84815803bo_tels
bowless123310313bowless
cetes75731103_cete_s
coatees93816553coatees
coaters93525793coaters
coatless1039693coatless
codeless112010113codeless
colters93522443colters
comtes106222813comte_s
confess12399903confess
contes84432913conte_s
contessa1044583contessa
contest93523233contest
contests103413383contests
cooters94525723cooters
copters113621283copters
coreless103013833coreless
costers94128333costers
costless10310003costless
cotes76347843co_te_s
cotters94323443cotters
countess103710053countess
couters93827303couters
coveters132411083coveters
coxless1637743coxless
coyness1277323coyness
deters74724683_deters
detest74122843_detest
detests83711743_detests
dieters83216433dieters
doneness9411513doneness
doters74423913do_ters
dotes65836693do_te_s
dottels8327783dottels
dotters83715973dotters
dueness82310123dueness
eyeless1058053eyeless
feeless103511103feeless
feetless1137383feetless
fetes85630143_fete_s
foetors1039763foetors
foetus958523foet_us
foetuses1136083foetuses
fogless1138193fogless
footers104618333footers
footless113710803footless
fortes95327183forte_s
fortress1136753fortress
fosters104220103fosters
fretless1138063fretless
goatees82710443goatees
goddess1035263goddess
godless938403godless
goiters84014443goiters
goneness9310763goneness
holeless1189363holeless
homeless131110133homeless
hooters104520473hooters
hopeless13118303hopeless
hostels103712313hostels
hotels94515513ho_tels
hotness1038613hotness
hottest10411383hottest
hueless1058823hueless
iceless9219963iceless
ireless72312243ireless
jetes124922843_jete_s
jobless16237563jobless
jolters143711993jolters
jotters143413803jotters
joyless17226513joyless
loess55714703lo__ess
loesses7310033loesses
lofters103912903lofters
loftless1135903loftless
loiters74116613loiters
loneness8512093loneness
looters74419163looters
lostness837683lostness
lotters73921063lotters
lottes65322753lotte_s
loveless1168573loveless
lowness1037813lowness
meeters94714543meeters
meetness1036653meetness
meters85625833_meters
metes74736213_mete_s
molters93816973molters
montes84226933monte_s
mooters93818623mooters
mootness1036753mootness
moreness10911573moreness
mostest9314793mostest
mostests1036833mostests
motels83616893mo_tels
motes75944003mo_te_s
motets84216193mo_tets
mottes85523693motte_s
moveless1367753moveless
netless739863_netless
noseless839513noseless
noteless839403noteless
noters64021003no_ters
notes55034583no_te_s
nowness1037033nowness
oaters65029793_oaters
obsess845943_obsess
obtest81213013_obtest
obtests9136233_obtests
octets839403_octets
oftest91212003_oftest
ogress7529503_ogress
oneness7512143oneness
openers9339493openers
openest9312913openest
openness1035473openness
oppress1135993oppress
otters64021513_otters
outers64230173_outers
oxters134813273_oxters
paleness10312983paleness
palters94021683palters
paneless102611763paneless
pastels95215183pastels
pasters94531733pasters
pastes85233913paste_s
pastless102411203pastless
pastness102510503pastness
patens84820863p_atens
paters84935833p_aters
pates76047893p_ate_s
patness92912283patness
pattens95414923pattens
patters94825193patters
peases85229473p_eases
pectens11189203pectens
pedes85327293p_ede_s
peeks115021113p_e_eks
peelers93615593peelers
peels75226423p_e_els
peens76428193p_e_ens
peepers113713673peepers
peeps95822363p_e_eps
peerless1037513peerless
peers75130273p_e_ers
pees65257373p_e_e_s
peeves113814873peeve_s
peewees1236803peewees
pegless1038053pegless
peises84125043p_eises
pekes114623563p_eke_s
peles75738083p_ele_s
pelters93720313pelters
peltless10267373peltless
penes75839223p_ene_s
peones83821043peone_s
peres76246643p_ere_s
perses85428063p_erses
pertest9317043pertest
pertness10310093pertness
pesters93827093pesters
petals84719813p_etals
petasos948603p_etasos
petasus946363p_etasus
peter74427593p_ete_r
petrels9279373p_etrels
pets66248333p_et__s
petters93722363petters
pewees11311393p_ewees
pewters124113353pewters
phereses1348093phereses
pheresis1377633pheresis
phoebes1435813phoebe_s
piecers114112253piecers
pieces104217273piece_s
pietas84516503piet_as
pieties9419223pieties
pietism1139113pietism
pietisms1247463pietisms
pietist9414033pietist
pietists1038323pietists
pileless1088623pileless
pipeless12107663pipeless
pistes85325633piste_s
platens94213983platens
platers93924093platers
plates85432243plate_s
pleases94515483pleases
pleaters103613793pleaters
pleatless1134613pleatless
plebes104313623plebe_s
plexes155313543plexe_s
plotless10256793plotless
plotters104011553plotters
pluteus9326243pluteus
pocketers17196493pocketers
pockets154612253pockets
podites103014733podite_s
poems95715553po__ems
poesies93217403poesies
poesy105014063po__esy
poet65552903poet___
poetic10416843poet_ic
poetised1138523poetised
poetiser1037313poetiser
poetisers1145303poetisers
poetize18310773poetize
poetizers2045103poetizers
poetizes19310253poetizes
poetries10315583poetries
poetry1139383poet_ry
pogeys124110353po_geys
pogies94123543pogie_s
pointers103013723pointers
pointes93216753pointe_s
pointless1135703pointless
poisers94214433poisers
poises84226543poise_s
poitrels1035243poitrels
pokers124617923po_kers
pokes116133013po_ke_s
pokeys15529513po_keys
pokies125921333pokie_s
pokiest133314913pokiest
pokiness14219863pokiness
polders103617373polders
poleis86018353po_leis
polers84225643po_lers
poles75351003po_le_s
polies84034583polie_s
politesse1143673politesse
politest10312943politest
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
pomes94833933po_me_s
pommels13235783pommels
ponces104720843ponce_s
ponders103618843ponders
pones74547043po_ne_s
pongees104212543pongees
ponies84833463ponie_s
pontils9312213pontils
pontons93315553pontons
poofters1336923poofters
poolers94217423poolers
poorest9312773poorest
poorness1036363poorness
pooves113914713poove_s
popes95933813po_pe_s
poppers103414863poppers
poppets10338853poppets
pores75849033po_re_s
porkers134314933porkers
portals94015563portals
ported94223243porte_d
portend103411193portend
portends11358963portends
portent93619643portent
portents103512823portents
porter84224413porte_r
porteress1137933porteress
ports75934593port__s
posers84223973po_sers
poses74642763po_se_s
poshest12312423poshest
poshness1356653poshness
posies84431433posie_s
posses85128803posse_s
possets94212773possets
postals93716373postals
posted93722493poste_d
posteen93512623posteen
posteens10309733posteens
poster84129173poste_r
postern93615613postern
posterns102713723posterns
posties93128813posties
postins93721203postins
postops11311713postops
posts75228783post__s
posttest10410233posttest
posttests1144973posttests
potash1138273po_tash
poteen83514263po_teen
potent84223353po_tent
pothers123818623pothers
pothos114214693po_thos
pots66452363po_t__s
potsy105815613po_t_sy
potted94624013potte_d
potteen9319673potteen
potteens10256793potteens
potter83926983potte_r
pottery123011073pottery
potties93723543potties
pottiest102815973pottiest
pottiness1179703pottiness
pottles93816983pottles
pottos84615873po_ttos
potzers184010543potzers
poulters103911053poulters
pourers93513673pourers
pouted94021393poute_d
pouter83923983poute_r
poutiest103016793poutiest
pouts75530323pout__s
powders134111553powders
powerless1444293powerless
powers113822323po_wers
powter114116033powte_r
poxes145325723po_xe_s
poxiest163412253poxiest
praters94921653praters
prates84633163prate_s
prebless1236823prebless
preens85020113pre_ens
prees75937173pre_e_s
prefers123713333prefers
premeds12389593premeds
premiss113513813premiss
prepress12137983prepress
presets94216423presets
press75425953p__ress
presses93523153presses
presters103419003presters
prestress1138133prestress
preteen939873preteen
preteens1038123preteens
pretell938243pretell
pretells1047333pretells
pretend104011013pretend
pretends11299113pretends
pretense10199823pretense
pretenses112210593pretenses
preterm11310163preterm
preterms1237223preterms
pretext1639663pretext
pretexts1735603pretexts
pretors9316813pretors
pretzels1934033pretzels
prexes154915953prexe_s
preyers124412363preyers
prezes173614693preze_s
priestess1145293priestess
process11310403process
proettes10312763proettes
profess1237713profess
progress1137023progress
proneness11310443proneness
prophetess1744243prophetess
proteas92015123proteas
protest9317533protest
protests10310493protests
proteus92511593proteus
prowess1237903prowess
punters93617043punters
pureness101110183pureness
puttees93612913puttees
putters94219193putters
recess8314263_recess
retems83914573_retems
retest64028453_retest
retests73813853_retests
rodless8310073rodless
rooters74522933rooters
rootless83910443rootless
rosters73727543rosters
rotes56143903ro_te_s
rotters74421393rotters
rottes64524833rotte_s
routers74822873routers
routes66129313route_s
seeress7311573seeress
shoeless1137803shoeless
softens10347623softens
softest10310603softest
softness1136433softness
soleless8910033soleless
soleness8814263soleness
sonless72612613sonless
soreness8914793soreness
sorters74221133sorters
souters74422603souters
sporters103714063sporters
spotless1037043spotless
spotters104313383spotters
spouters104011163spouters
spoutless1134243spoutless
teeters74018303teeters
tieless72512563tieless
toneless8610393toneless
tooters73818773tooters
tootses72910773tootses
topless92511123topless
tortes64826053torte_s
totems86810763to_tems
toters65026363to_ters
totes55139683to_te_s
totters74618733totters
touters74018353touters
toyless10268713toyless
tsetses785453tsetses
ureters7311823ureters
useless7188423useless
voltes94915583volte_s
voteless1137493voteless
voters95017443vo_ters
votes84627083vo_te_s
votress1035483votress
vowless13246603vowless
waeness102512783waeness
wetness10277723_wetness
yokeless1535303yokeless
zoneless1737823zoneless
zosters163015413zosters

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 Filter1786911340270.470380193.6
2DLD Change Limit1340274567.29618369.9
3Display Results4564560.1702682.4
 (SQL Overall)1786914567.93622516.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.