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

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

162 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
downrightnesses238921downrightnesses_
downrightness21151023downrightne_s_s_
brightnesses1844185___brightnesses_
donnishnesses1784115do_nnish_nesses_
downinesses1536145down_i___nesses_
rightnesses1546235____rightnesses_
uprightnesses19122785__uprightnesses_
airtightnesses1851846_airtightnesses_
boorishnesses1864316bo_orish_nesses_
clownishnesses2262276clown_ish_nesses_
doggishnesses19143686do_ggish_nesses_
dollishnesses1744376do_llish_nesses_
doltishnesses1744616do_ltish_nesses_
doughtinesses1852556do___ughtinesses_
dovishnesses1944466do__vish_nesses_
dowdinesses1635726dow_di___nesses_
downwardnesses2291606down_wardnesses_
dwarfishnesses2492136d_warfish_nesses_
gastightnesses19131836_gastightnesses_
lightnesses1546146____lightnesses_
nighnesses1446466___n_igh_nesses_
owlishnesses1844646_ow_lish_nesses_
slightnesses1654626___slightnesses_
straightnesses1872586_straightnesses_
tightnesses1565586____tightnesses_
uptightnesses1982226__uptightnesses_
weightinesses2052906__w_eightinesses_
almightinesses2051847__almightinesses_
ancientnesses1553287__ancientnesses_
bearishnesses1844847_bearish_nesses_
benightednesses2262417_ben_ightednesses_
boninesses121111457bo_n_i___nesses_
bonninesses1337357bo_nni___nesses_
bookishnesses2263687bo_okish_nesses_
boringnesses15105027bo__ri_ngnesses_
bountifulnesses2073197bountifulnesses_
boyishnesses2044037bo__yish_nesses_
brightness1644577___brightne_s_s_
clannishnesses1952987clannish_nesses_
colorfastnesses2061307colorfastnesses_
coltishnesses1845227co_ltish_nesses_
concisenesses1746597co_nci_senesses_
conjugatenesses25132417co_njugatenesses_
contritenesses1655497contri_tenesses_
corninesses13410607corn_i___nesses_
correctnesses1754217co__rrectnesses_
corruptnesses1752847co__rruptnesses_
covertnesses1746337cover___tnesses_
cowardlinesses2052517cowar_dlinesses_
daintinesses1346247dainti___nesses_
daringnesses1464847d__ari_ngnesses_
delightednesses2162537d__elightednesses_
deliriousnesses1656057deliriousnesses_
devilishnesses2152697devilish_nesses_
dewinesses1438357dew__i___nesses_
dinginesses1337477d_in__g_inesses_
directnesses1595287d__ir_ectnesses_
discreetnesses1762437discr_eetnesses_
distinctnesses1752567d_istinctnesses_
dodginesses1435437do___dg_inesses_
doggednesses1643707do___ggednesses_
dolorousnesses1555787dolor_ousnesses_
donenesses11310567do_n____enesses_
donnishness1543897do_nnish_ne_s_s_
dopinesses13159727do__pi___nesses_
dorkinesses1647667do__r__kinesses_
dottinesses1238137do_tti___nesses_
dournesses1138247do_ur____nesses_
downiness13106717down_i___ne_s_s_
downlights1842847downlight_____s_
downright1743307downright_______
downrightly226767downright_____ly
dozinesses20168637do__zi___nesses_
drearinesses1347447dreari___nesses_
drivennesses1643837d___rivennesses_
droughtinesses1951837d__roughtinesses_
drowsinesses1644397drow_si___nesses_
dwarfnesses1843297d_war___fnesses_
faintishnesses2053307faintish_nesses_
feverishnesses2382887feverish_nesses_
fiendishnesses2172477fiendish_nesses_
flightinesses2053137___flightinesses_
flowerinesses1942907floweri___nesses_
folkishnesses2343927fo_lkish_nesses_
foolishnesses1944467fo_olish_nesses_
foppishnesses2343397fo_ppish_nesses_
foreignnesses1752757fo_reig_nnesses_
forgivenesses2045847fo__rgivenesses_
forthrightness247887forthrightne_s_s_
frigidnesses1743647___frigidnesses_
garishnesses1645907__garish_nesses_
gawkishnesses2443037gaw_kish_nesses_
gorinesses11311557go__ri___nesses_
hawkishnesses2643257haw_kish_nesses_
highnesses1746087____high_nesses_
hoarinesses14310227ho_ari___nesses_
hoggishnesses21143657ho_ggish_nesses_
horninesses1459007horn_i___nesses_
horriblenesses1953907ho_rriblenesses_
horridnesses1644467ho_rri__dnesses_
jowlinesses2135327jow_li___nesses_
knightlinesses2282447__kn_ightlinesses_
liverishnesses2063027liverish_nesses_
longnesses1138507lo_n__g__nesses_
looninesses1197997loon_i___nesses_
loutishnesses1644997lo_utish_nesses_
lowlinesses1436687low_li___nesses_
mannishnesses1873967_mannish_nesses_
mawkishnesses2543137maw_kish_nesses_
mightinesses1844387____mightinesses_
modishnesses1844737mo__dish_nesses_
moistnesses1347157mo___i_stnesses_
mooninesses13127947moon_i___nesses_
naughtinesses1752417___naughtinesses_
nightdresses1752207___n_ightdresses_
oafishnesses1844777_o_afish_nesses_
offishnesses2143817_o_ffish_nesses_
ornerinesses1246577_orneri___nesses_
overtnesses1448717_over___tnesses_
pinkishnesses2243987_pinkish_nesses_
powerlessnesses1954497powerlessnesses_
prankishnesses2353207prankish_nesses_
richnesses1537807____rich_nesses_
rightness13117357____rightne_s_s_
rigidnesses1345927____rigidnesses_
roguishnesses1763977ro_guish_nesses_
roughnesses15105137ro___ugh_nesses_
rowdinesses1536967row_di___nesses_
songstresses1252017so_n__gstresses_
sorrinesses11310097so_rri___nesses_
sottishnesses1544457so_ttish_nesses_
sprightlinesses2161827__sprightlinesses_
squarishnesses2552447squarish_nesses_
strictnesses1445417__stri_ctnesses_
swarthinesses1943457_swar_thinesses_
swartnesses1436717_swar___tnesses_
swiftnesses1744507_sw__i_ftnesses_
swinishnesses1843657_swinish_nesses_
tawdrinesses1643437tawdri___nesses_
tawninesses1436157tawn_i___nesses_
tigerishnesses1852787tigerish_nesses_
torridnesses1344657to_rri__dnesses_
toughnesses15104487to___ugh_nesses_
towardlinesses1851917towar_dlinesses_
trignesses1188217___trig__nesses_
unfitnesses1446137__unfi__tnesses_
unripenesses1446017__unri_penesses_
unsightlinesses1962217__unsightlinesses_
unwarinesses1546157unwari___nesses_
unworthinesses2052677unwor_thinesses_
uprightness1752857__uprightne_s_s_
vaporishnesses2252237vaporish_nesses_
voguishnesses2063497vo_guish_nesses_
warinesses131514537__wari___nesses_
waterishnesses2053167waterish_nesses_
weightlessness2162427__w_eightlessness
wirinesses131811537__wiri___nesses_
witnesses12219927__w__i__tnesses_
wolfishnesses2243737wo_lfish_nesses_
womanishnesses2252827womanish_nesses_
worthinesses1845767__wor_thinesses_
youngnesses1544287youn__g__nesses_

Search took 9 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 Limit950241627.70312336.0
3Display Results1621620.1261285.7
 (SQL Overall)1786911628.18921820.9
 
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.