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

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

115 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
donnishness154389(None) 
doggishness1793472doggishness
dollishness1544012dollishness
doltishness1544212doltishness
donnishnesses1784112donnishnesses
dovishness1744462do_vishness
mannishness1643972mannishness
bonniness1136733bonni__ness
bookishness2043693bookishness
boorishness1644243boorishness
boyishness1843963bo_yishness
clannishness1752813clannishness
clownishness2052283clownishness
coltishness1645043coltishness
conciseness1546663conciseness
downiness13106713downi__ness
folkishness2143833folkishness
foolishness1744493foolishness
foppishness2153493foppishness
hoggishness1983583hoggishness
loutishness1444543loutishness
modishness1644553mo_dishness
oafishness1644463_oafishness
offishness1943793_offishness
owlishness1644163_owlishness
pinkishness2043833pinkishness
roguishness1563633roguishness
sottishness1444433sottishness
swinishness1743573swinishness
voguishness1843283voguishness
wolfishness2043733wolfishness
womanishness2052703womanishness
apishness1445744__apishness
bearishness1644544bearishness
bluishness1544594_bluishness
boniness102211804bo_ni__ness
brutishness1643554brutishness
bullishness1643954bullishness
caddishness1843414caddishness
canniness1138644canni__ness
cloddishness1952504cloddishness
corniness112611184corni__ness
cultishness1644334cultishness
cunningness1452934cunningness
danishes121710494d_anish_e_s
denseness1046864d_en_seness
devilishness1962384devilishness
dinginess1137824dingi__ness
dodginess1235284dodgi__ness
dogfishes1745084dogfish_e_s
doggishnesses19143684doggishnesses
dollishnesses1744374dollishnesses
doltishnesses1744614doltishnesses
doneness9411514do_n__eness
donnickers1782614donni_ckers
donnikers1443444donni__kers
donnish11187634donnish____
donnishly1643334donnish__ly
dopiness11289974do_pi__ness
dorkiness14248054dorki__ness
dottiness1058044dotti__ness
dovishnesses1944464do_vishnesses
dowdiness1485694dowdi__ness
downrightness21151024downrightness
doziness18228554do_zi__ness
dwarfishness2292024dwarfishness
faddishness1943244faddishness
faintishness1863064faintishness
fiendishness1952334fiendishness
funniness12256534funni__ness
garishness1445744_garishness
gawkishness2243074gawkishness
ghoulishness1952344ghoulishness
girlishness1573654girlishness
greenishness1653154greenishness
hawkishness2443274hawkishness
hellishness1744114hellishness
horniness12309144horni__ness
impishness1744124_impishness
lavishness1644714_lavishness
looniness9137574looni__ness
lumpishness1843154lumpishness
mannishnesses1873964mannishnesses
mawkishness2343034mawkishness
moistness1146344mo__istness
monishes13311484mo_nish_e_s
mooniness11157864mooni__ness
mulishness1544544_mulishness
nighness1236104___nighness
noisiness948344__noisiness
nonbusiness1353064nonbusiness
peevishness1943144peevishness
pettishness1643974pettishness
piggishness1873144piggishness
poshness1356654po___shness
prankishness2153054prankishness
prudishness1743574prudishness
puckishness2243244puckishness
raffishness2043374raffishness
rakishness1744614_rakishness
reddishness1643434reddishness
runniness9247104runni__ness
ruttishness1443614ruttishness
selfishness1743814selfishness
sickishness2043654sickishness
slavishness1753704slavishness
snobbishness1952094snobbishness
stylishness1743444stylishness
sunniness9247944sunni__ness
swainishness1852294swainishness
tinniness936094tinni__ness
uppishness1743494_uppishness
waggishness1943024waggishness
waspishness1943084waspishness
wimpishness2143214wimpishness

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191159.40615821.7
3Display Results1151150.0631825.4
 (SQL Overall)1786911159.89218064.2
 
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.