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

137 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
openness103547(None) 
dopeyness1543472dopeyness
evenness1135542evenness
keenness1234882keenness
oneness7512142one_ness
openers9339492ope_ners
openest9312912ope_nest
opennesses1246312opennesses
penners93414182_penners
agedness1036683agedness
alienness945373alienness
aptness9268573ap_tness
bennes86019013_benne_s
bennets94712163_bennets
brokenness1643323brokenness
cleanness1144973cleanness
deepness1136443deepness
doneness9411513done_ness
dopiness11289973dop_iness
doyennes1244363doyenne_s
dueness82310123due_ness
dunness8298983_dunness
eyedness1245103eyedness
fennecs12305693_fennecs
fennels10387903_fennels
fewness1335003_fewness
feyness1334923_feyness
fineness11310653fineness
freeness11710443freeness
frozenness2242683frozenness
glegness1034613glegness
goldenness1243413goldenness
goneness9310763gone_ness
gooeyness1343543gooeyness
governess1346173governess
greenness1046793greenness
greyness1235243greyness
hokeyness1943803hokeyness
homeyness1745023homeyness
hopeless13118303hope_less
ironness836953ironness
jennets14517633_jennets
kennels11387193_kennels
leanness837373leanness
loneness8512093lone_ness
lornness836493lornness
meanness1037183meanness
meekness1434303meekness
meetness1036653meetness
modernness1343523modernness
mopiness12259063mop_iness
moreness10911573more_ness
newness1035703_newness
notedness1047323notedness
obeseness1145893obeseness
oddness935313o_ddness
oiliness8311563oiliness
oldness836403o_ldness
oleines7313393oleine_s
ooziness17237513ooziness
opencast1244873opencast
opened94311863ope_ne_d
opener83910993ope_ne_r
openings1134813openings
opens76118553ope_n__s
opines84820703op_ine_s
oppress1135993op_press
otherness1245513otherness
ovalness1134673ovalness
overtness1238223overtness
panners93621273_panners
pannes85522853_panne_s
patness92912283_patness
peeress939503_peeress
pegless1038053_pegless
pencels113610063_pencels
penes75839223_pe_ne_s
penises9318193_penises
penne75423853_penne__
penned94217613_penne_d
penner84616663_penne_r
pennies94218813_pennies
penniless1144013_penniless
pennis84315743_penn_is
pennons939713_pennons
pensees9311203_pensees
peones83821043_peone_s
pertness10310093_pertness
pinkness1436513_pinkness
pinners93518603_pinners
poetess938933poe_tess
poetless1038723poetless
pokiness14219863pokiness
poorness1036363poorness
popeless1288473pope_less
poshness1356653poshness
properness1445923properness
puniness101610273_puniness
punners94114243_punners
punnets9409263_punnets
redness82012443_redness
rennets75212633_rennets
ripeness1039373ripe_ness
ropiness102311073rop_iness
rottenness1043763rottenness
saneness82313723saneness
sennets73712583_sennets
skewness1533763skewness
soberness1186463soberness
soddenness1242903soddenness
solemnness1243213solemnness
soleness8814263sole_ness
soppiness1336543soppiness
soreness8914793sore_ness
spanless10247363spanless
spanners103710773spanners
spencers12269193spencers
spences113413923spence_s
spenders113211743spenders
spenses92913573spense_s
spininess1137963spininess
spinless10238703spinless
spinners103810863spinners
spinneys13335553spinneys
spryness1334003spryness
sternness946093sternness
tenners74014923_tenners
thinness11277173thinness
tweeness11246403tweeness
vainness1136063vainness
waeness102512783wae_ness
wanness102610683_wanness
wetness10277723_wetness
woeness1020211543woe_ness
womanness1444473womanness
woodenness1443723woodenness
wornness1136363wornness

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.453394461.4
2DLD Change Limit1461621377.46619577.0
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.