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

110 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
waggishnesses214328(None) 
doggishnesses19143682doggishnesses
hoggishnesses21143652hoggishnesses
piggishnesses2043282piggishnesses
waggishness1943022waggishne_s_s
waspishnesses2043282waspishnesses
apishnesses1646373_a_pishnesses
bagginesses1545953baggi__nesses
caddishnesses2043373caddishnesses
dwarfishnesses2492133dwarfishnesses
faddishnesses2143243faddishnesses
garishnesses1645883ga_rishnesses
gawkishnesses2443033gawkishnesses
hawkishnesses2643253hawkishnesses
lavishnesses1844773la_vishnesses
mannishnesses1873963mannishnesses
mawkishnesses2543133mawkishnesses
oafishnesses1844773oa_fishnesses
priggishnesses2152373priggishnesses
raffishnesses2243223raffishnesses
rakishnesses1944993ra_kishnesses
roguishnesses1763973roguishnesses
sluggishnesses1852143sluggishnesses
swainishnesses1952323swainishnesses
voguishnesses2063493voguishnesses
waterishnesses2053163waterishnesses
wimpishnesses2343583wimpishnesses
wolfishnesses2243733wolfishnesses
agilenesses1247774_a_gilenesses
algidnesses1345164_algi_dnesses
augustnesses1352684_augustnesses
bearishnesses1844844bearishnesses
bluishnesses1765264_bluishnesses
bogginesses1555674boggi__nesses
bookishnesses2263684bookishnesses
boorishnesses1864314boorishnesses
boyishnesses2044034_boyishnesses
brackishnesses2552644brackishnesses
brutishnesses1844094brutishnesses
bugginesses1545374buggi__nesses
bullishnesses1844044bullishnesses
caginesses13310944ca_gi__nesses
clannishnesses1952984clannishnesses
coltishnesses1845224coltishnesses
cragginesses1644504craggi__nesses
cultishnesses1844564cultishnesses
doggishness1793474doggishne_s_s
dollishnesses1744374dollishnesses
doltishnesses1744614doltishnesses
donnishnesses1784114donnishnesses
dovishnesses1944464_dovishnesses
faintishnesses2053304faintishnesses
fogginesses1645494foggi__nesses
folkishnesses2343924folkishnesses
foolishnesses1944464foolishnesses
foppishnesses2343394foppishnesses
girlishnesses1744034girlishnesses
haggardnesses1952254haggardnesses
harshnesses1745854ha__rshnesses
hellishnesses1974354hellishnesses
hoggishness1983584hoggishne_s_s
impishnesses1944294_impishnesses
jaggednesses2242794jagg_ednesses
laggardnesses1652394laggardnesses
legginesses1345294leggi__nesses
loutishnesses1644994loutishnesses
lumpishnesses2043474lumpishnesses
manginesses1499594mangi__nesses
modishnesses1844734_modishnesses
mugginesses1544924muggi__nesses
mulishnesses1755094_mulishnesses
offishnesses2143814_offishnesses
owlishnesses1844644_owlishnesses
peevishnesses2143474peevishnesses
pettishnesses1844384pettishnesses
pigginesses1555614piggi__nesses
piggishness1873144piggishne_s_s
pinkishnesses2243984pinkishnesses
prankishnesses2353204prankishnesses
prudishnesses1943674prudishnesses
puckishnesses2443334puckishnesses
pugginesses1545254puggi__nesses
qualmishnesses2852084qualmishnesses
raggednesses1543864ragg_ednesses
ranginesses121210114rangi__nesses
rashnesses1338724ra___shnesses
reddishnesses1873584reddishnesses
ruttishnesses1644044ruttishnesses
selfishnesses1844044selfishnesses
shagginesses1743964shaggi__nesses
sickishnesses2143664sickishnesses
slavishnesses1843684slavishnesses
snappishnesses2052264snappishnesses
sogginesses1346774soggi__nesses
sottishnesses1544454sottishnesses
stylishnesses1843404stylishnesses
swinishnesses1843654swinishnesses
tanginesses1278884tangi__nesses
tigerishnesses1852784tigerishnesses
uppishnesses1943604_uppishnesses
vaporishnesses2252234vaporishnesses
wackinesses2036654wacki__nesses
warinesses131514524wa_ri__nesses
washinesses1737264wa___shinesses
waspinesses1636704waspi__nesses
waspishness1943084waspishne_s_s
wavinesses16199284wa_vi__nesses
waxinesses20138764wa_xi__nesses
wisenesses13310824w___isenesses
womanishnesses2252824womanishnesses

Search took 5 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 Filter178691950240.360496363.9
2DLD Change Limit950241104.12323047.3
3Display Results1101100.0801375.0
 (SQL Overall)1786911104.56339160.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.