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

271 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
sourness83954(None) 
dourness947681dourness
bournes93615022bourne_s
foulness11236652foulness
journeys1843202journeys
loudness937012loudness
mourners1036912mourners
poorness1036362poorness
smugness1143812smugness
snubness1044372snubness
snugness934322snugness
soberness1186462soberness
softness1136432softness
soleness8814262soleness
soreness8914792soreness
sorners73416872so_rners
sorriness939582sorriness
soulless8218762soulless
soundness1036962soundness
soupless10268462soupless
sources9312172source_s
sourest7515712sour_est
sournesses10310012sournesses
sourpuss1042312sourpuss
spurners10288492spurners
stoutness945862stoutness
sureness8912902s_ureness
tourneys1134012tourneys
blueness1038213blueness
bogusness1243563bogusness
boldness1136973boldness
boniness102211803boniness
boundness1235943boundness
bourne83714093bourne__
bourns84114063bourn__s
bourrees10127643bourrees
bourses94014303bourse_s
boxiness17247813boxiness
burgess10409343_burgess
burners94115673_burners
burnets93813263_burnets
churners13316893churners
coldness1137953coldness
coolness1037743coolness
corneas94717003co_rneas
cornels94716663co_rnels
corners94723313co_rners
cornets94820573co_rnets
cosiness103214283cosiness
countess103710053countess
couriers103213173couriers
coursers104412303coursers
courses94218893course_s
courters103015373courters
courtesy1364973courtesy
coyness1277323co_yness
coziness19319823coziness
curtness1037263_curtness
dearness939973dearness
doneness9411513doneness
doorless936713doorless
dopiness11289973dopiness
dourest8312943dour_est
dourines9311373dourine_s
dournesses1138243dournesses
doziness18228553doziness
dueness82310123_dueness
dulness8307983_dulness
dunness8298983_dunness
duress74712063_dur_ess
fairness1136563fairness
farness102912203_farness
flourless1243533flourless
fondness1237213fondness
foxiness18257403foxiness
foziness20257803foziness
fulness10248963_fulness
furless103210143_furless
gluiness937363gluiness
glumness1135203glumness
goneness9310763goneness
goodness1036253goodness
goriness9310753goriness
gourdes9109383gourde_s
gourmets1144153gourmets
goutiness1038763goutiness
governess1346173governess
gurnets84010793_gurnets
gurneys11406463_gurneys
harness102413933_harness
hoariness1238823hoariness
hokiness152510183hokiness
holiness112512503holiness
hominess132712453hominess
hornets104113553ho_rnets
hornless1137363ho_rnless
hotness1038613ho_tness
jokiness19227393jokiness
journals1574353journals
journey1734873journe_y
journos14134943journ_os
loginess9310163loginess
loneness8512093loneness
longness938553longness
lornness836493lornness
lostness837683lostness
lousiness9219033lousiness
lowness1037813lo_wness
mootness1036753mootness
mopiness12259063mopiness
moreness10911573moreness
mourned1037763mourne_d
mourner938093mourne_r
mourns84111013mourn__s
mousiness11219023mousiness
nearness838313nearness
nosiness83211393nosiness
nounless837253nounless
nowness1037033no_wness
oarless73913373_oarless
oddness935313_oddness
ogress7529503_ogr_ess
oldness836403_oldness
oneness7512143_oneness
ooziness17237513ooziness
piousness1147633piousness
pokiness14219863pokiness
poshness1356653poshness
pourers93513673pour_ers
proudness1246693proudness
pureness101110183_pureness
ropiness102311073ropiness
rosiness82613173rosiness
roughness1345763roughness
roundness1047013roundness
sadness8310613s_adness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
saneness82313723saneness
sauciness1138043sauciness
saurels749303saur_els
sauries72821623saurie_s
scariness11310183scariness
scarless10189053scarless
scorners10228493scorners
scourers10348533scour_ers
scourgers1234383scourgers
scourges1136533scourge_s
scumless1254993scumless
scunners10357303scunners
scurviness1543283scurviness
secureness1245053secureness
seeress7311573seer_ess
selfness1135153selfness
sexiness1537943sexiness
sharpness1434933sharpness
sheerness1236273sheerness
shortness1236733shortness
showiness1576073showiness
shunners11317743shunners
shyness1344993s_hyness
sickness1437833sickness
siziness1737423siziness
skewness1533763skewness
slimness1036523slimness
slowness1135013slowness
slyness1035263s_lyness
smartness1136143smartness
smokiness1535543smokiness
snowiness1296243snowiness
soapiness1138293soapiness
soapless10278073soapless
soarers74118093soar_ers
sockless14267793sockless
sodaless936113sodaless
sogginess1136183sogginess
soilless8279033soilless
soirees72411643soir_ees
sojourners1761773sojourners
soleless8910033soleless
solidness1036903solidness
solonets838233solonets
somberness1443513somberness
sones55444143so__ne_s
songless9218823songless
sonless72612613so_nless
sonnets74211993so_nnets
sooners73916643so_oners
soonest7415593so_onest
sootiness999833sootiness
soppiness1336543soppiness
sorbets93012513so_rbets
sorels63921163so_r_els
sores55454283so_r_e_s
sorest65028003so_r_est
sorned74820043so_rne_d
sorner64720393so_rne_r
sorns55028423so_rn__s
soroses73117483so_roses
sorrels7310723so_rrels
sorriest8413883sorriest
sorters74221133so_rters
soubises10107993soubises
sounders93214113sounders
soundest9510973soundest
soundless1035533soundless
sounds74616183sou_n_ds
soupiest102212913soupiest
source8410673source__
sourced1038453source_d
sourceless1273013sourceless
sourdines1046743sourdine_s
soured74921863sour_e_d
sourer63620213sour_e_r
sourish10310693sour_ish
sours55230503sour___s
soursops1043213soursops
souses64229243sou_se_s
soutanes8312933soutane_s
souters74422603sou_ters
southers114214453southers
sozines16611263sozine_s
spareness1139863spareness
spoutless1134243spoutless
spryness1334003spryness
spurges104111653spurge_s
spurned10339263spurne_d
spurner9269653spurne_r
spurns84811383spurn__s
spurrers10338463spurrers
spurreys13364603spurreys
spurters103311703spurters
squareness1944763squareness
squatness1844943squatness
starkness1335963starkness
starless81610843starless
sternest8314433sternest
sternness946093sternness
stoniness938343stoniness
stoures74614163stour_e_s
stress66616673s_tr_ess
stunners8277923stunners
sturdiness1144843sturdiness
subnets92512083s_ubnets
success1146403s_uccess
suchness1335763suchness
sumless92611123s_umless
sunless73013693s_unless
surest65026763s_ur_est
surfers103614133s_urfers
surgers83517483s_urgers
surges73924593s_urge_s
surliness939943s_urliness
surpass938283s_urpass
surreys10489443s_urreys
surveys13357573s_urveys
swartness1236113swartness
tautness8217183tautness
toughness1355093toughness
tourers73512743tour_ers
tournedos1042533tournedos
tourney1036273tourne_y
trueness838693trueness
turners73912893_turners
voidness1235553voidness
votress1035483votr_ess
woeness1020211543wo_eness
wornness1136363wornness
youngness1343373youngness

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622716.59322169.3
3Display Results2712710.1102463.6
 (SQL Overall)1786912717.12625075.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.