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

101 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
reddishnesses187358(None) 
caddishnesses2043372caddishnesses
faddishnesses2143242faddishnesses
reddishness1643432reddishne_s_s
bearishnesses1844843bearishnesses
cloddishnesses2152623cloddishnesses
fiendishnesses2172473fiendishnesses
freakishnesses2452653freakishnesses
greenishnesses1882963greenishnesses
hellishnesses1974353hellishnesses
modishnesses1844733_modishnesses
peevishnesses2143473peevishnesses
pettishnesses1844383pettishnesses
prudishnesses1943673prudishnesses
raffishnesses2243223raffishnesses
rakishnesses1944993r_akishnesses
readinesses12611273readi__nesses
reedinesses1259563reedi__nesses
remissnesses1344953re_missnesses
roguishnesses1763973roguishnesses
ruddinesses1336033ruddi__nesses
ruttishnesses1644043ruttishnesses
selfishnesses1844043selfishnesses
apishnesses1646384__apishnesses
beadinesses1449564beadi__nesses
bluishnesses1765264_bluishnesses
bookishnesses2263684bookishnesses
boorishnesses1864314boorishnesses
boyishnesses2044034_boyishnesses
brackishnesses2552644brackishnesses
brutishnesses1844094brutishnesses
bullishnesses1844044bullishnesses
caddishness1843414caddishne_s_s
childishnesses2352564childishnesses
coltishnesses1845224coltishnesses
cultishnesses1844564cultishnesses
devilishnesses2152694devilishnesses
doggishnesses19143684doggishnesses
dollishnesses1744374dollishnesses
doltishnesses1744614doltishnesses
donnishnesses1784114donnishnesses
dovishnesses1944464_dovishnesses
edginesses1236704_edgi__nesses
faddishness1943244faddishne_s_s
feverishnesses2382884feverishnesses
folkishnesses2343924folkishnesses
foolishnesses1944464foolishnesses
foppishnesses2343394foppishnesses
freshnesses1746104fre___shnesses
garishnesses1645904_garishnesses
gawkishnesses2443034gawkishnesses
giddinesses1435314giddi__nesses
girlishnesses1744044girlishnesses
greedinesses1446474greedi__nesses
hawkishnesses2643254hawkishnesses
headinesses1539844headi__nesses
hoggishnesses21143654hoggishnesses
impishnesses1944294_impishnesses
lavishnesses1844774_lavishnesses
loutishnesses1644994loutishnesses
lumpishnesses2043474lumpishnesses
mannishnesses1873964mannishnesses
mawkishnesses2543134mawkishnesses
muddinesses1535274muddi__nesses
mulishnesses1755094_mulishnesses
needinesses1258104needi__nesses
nerdinesses1249054nerdi__nesses
oafishnesses1844774_oafishnesses
offishnesses2143814_offishnesses
owlishnesses1844644_owlishnesses
piggishnesses2043284piggishnesses
pinkishnesses2243984pinkishnesses
prankishnesses2353204prankishnesses
precisenesses1756284pre_cisenesses
priggishnesses2152374priggishnesses
puckishnesses2443334puckishnesses
randinesses121311204randi__nesses
rashnesses1338724r___ashnesses
redigresses1343944re_di_gresses
rediscusses1452254re_dis_cusses
rednesses10312314re_d___nesses
restivenesses1679444restivenesses
richnesses1537804r___ichnesses
rowdinesses1536964rowdi__nesses
seedinesses1259204seedi__nesses
sheepishnesses2153014sheepishnesses
shrewishnesses2262244shre_wishnesses
sickishnesses2143664sickishnesses
slavishnesses1843684slavishnesses
sottishnesses1544454sottishnesses
stylishnesses1843404stylishnesses
swinishnesses1843654swinishnesses
trendinesses1346324trendi__nesses
trickishnesses2352504trickishnesses
uppishnesses1943604_uppishnesses
voguishnesses2063494voguishnesses
waggishnesses2143294waggishnesses
waspishnesses2043284waspishnesses
weedinesses1557074weedi__nesses
wimpishnesses2343584wimpishnesses
wolfishnesses2243734wolfishnesses

Search took 6 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 Limit950241014.90319380.8
3Display Results1011010.0631603.2
 (SQL Overall)1786911015.32633550.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.