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

195 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
poorness103636(None) 
coolness1037742coolness
doorless936712doorless
dourness947682dourness
goodness1036252goodness
mootness1036752mootness
pokiness14219862pokiness
poorest9312772poor_est
poornesses1236802poornesses
poshness1356652poshness
sourness839542sourness
adorners9196623adorners
aloofness1242493aloofness
baroness101210063baroness
boldness1136973boldness
boniness102211803boniness
boonless10328353boonless
bootless103410983bootless
booziness20135613booziness
bournes93615023bourne_s
boxiness17247813boxiness
coldness1137953coldness
colorless1145683colorless
cookless14258633cookless
corneas94717003_corneas
cornels94716663_cornels
corners94723313_corners
cornets94820573_cornets
coronels104012143coronels
coroners104016223coroners
coronets103814363coronets
cosiness103214283cosiness
coyness1277323_coyness
coziness19319823coziness
dearness939973dearness
doneness9411513doneness
dopiness11289973dopiness
doziness18228553doziness
fairness1136563fairness
farness102912203_farness
floorless1243793floorless
fondness1237213fondness
foodless12338383foodless
footless113710803footless
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
goneness9310763goneness
gooeyness1343543gooeyness
goofiness1365603goofiness
gooneys11407073goo_neys
goriness9310753goriness
governess1346173governess
harness102413933_harness
hoariness1238823hoariness
hokiness152510183hokiness
holiness112512503holiness
hominess132712453hominess
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hornets104113553_hornets
hornless1137363_hornless
hotness1038613_hotness
ironness836953ironness
jokiness19227393jokiness
journeys1843203journeys
kookiness1235563kookiness
lioness739103lio_ness
loginess9310163loginess
loneness8512093loneness
longness938553longness
looneys10487013loo_neys
looniness9137573looniness
loopiness11136543loopiness
looseness937473looseness
lornness836493lornness
lostness837683lostness
loudness937013loudness
lowness1037813_lowness
moodiness12197593moodiness
mooners94015343moo_ners
mooniness11157863mooniness
moonless10278043moonless
moorhens1344853moorhens
mooriest102812723mooriest
mopiness12259063mopiness
moreness10911573moreness
motorless1145723motorless
mourners1036913mourners
nearness838313nearness
nosiness83211393nosiness
nowness1037033_nowness
oarless73913373_oarless
oddness935313_oddness
odorless934173odorless
ogress7529503_ogr_ess
oldness836403_oldness
oneness7512143_oneness
ooziness17237513ooziness
openness1035473openness
oppress1135993oppr_ess
packness1636933packness
paleness10312983paleness
pastness102510503pastness
patness92912283p_atness
patroness1137483patroness
peartness1137773peartness
peeress939503peer_ess
peerless1037513peerless
peones83821043peo_ne_s
pertness10310093pertness
phones114121213pho_ne_s
phoneys15437143pho_neys
phoniness1436303phoniness
phoresy1534653phor_esy
pinkness1436513pinkness
piousness1147633piousness
pipiness1238003pipiness
pixiness1736093pixiness
plotless10256793plotless
poetess938933p_oetess
poetless1038723poetless
poleless1089873poleless
pones74547043p_o_ne_s
pooches143214163pooche_s
poodles103013513poodle_s
poofters1336923poofters
poolers94217423poo_lers
poons75430973poo_n__s
poorer82613993poor_e_r
pooris83916843poor__is
poorish123712303poor_ish
pooves113914713poo_ve_s
popeless1288473popeless
pores75849033p_or_e_s
porkers134314933p_orkers
porkiness15249193porkiness
porniest103214313p_orniest
pornos85015253p_orn_os
porns75527343p_orn__s
porousness1248443porousness
porters93722703p_orters
portless10310643portless
portress1038323portress
possess9419123p_ossess
pottiness1179703pottiness
pourers93513673pour_ers
powerless1444293powerless
press75425953p__r_ess
primness1276763primness
prioress1035393prior_ess
process11310403pro_cess
profess1237713pro_fess
progress1137023progress
proneness11310443proneness
properness1445923properness
prosiness11311683prosiness
proudness1246693proudness
prowess1237903pro_wess
puniness101610273puniness
pureness101110183pureness
pyrones123113303pyrone_s
roofless11316733roofless
roominess1157303roominess
rootiness979063rootiness
rootless83910443rootless
ropiness102311073ropiness
rosiness82613173rosiness
scorners10228493scorners
shortness1236733shortness
slowness1135013slowness
soberness1186463soberness
softness1136433softness
soleness8814263soleness
sooners73916643soo_ners
soonest7415593soo_nest
sootiness999833sootiness
soreness8914793soreness
sorners73416873_sorners
sorriness939583sorriness
spookiness1644433spookiness
spooneys13314583spoo_neys
thornless1243633thornless
toolless836343toolless
tourneys1134013tourneys
voidness1235553voidness
votress1035483votr_ess
woeness1020211543_woeness
woodiness13147873woodiness
woodless12278453woodless
wooliness12147693wooliness
wooziness21125213wooziness
wornness1136363wornness

Search took 9 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.420425454.8
2DLD Change Limit1461621957.59619242.0
3Display Results1951950.0762565.8
 (SQL Overall)1786911958.09222082.4
 
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.