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

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

104 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
stalwartnesses175129(None) 
stalwartness1551502stalwartne_s_s
swartnesses1436713s___wartnesses
alertnesses1147234__al_ertnesses
apartnesses1346824__a_partnesses
awarenesses1447254__a_warenesses
saltnesses10310164s_al___tnesses
salutarinesses1462774s_alutarinesses
smartnesses1337144s___martnesses
stalenesses11311104stal___enesses
starknesses1545884st___arknesses
steadfastnesses188874steadfastnesses
stewardesses1651474st_ewar_desses
straitnesses1246214st__raitnesses
tartnesses101110714_t___artnesses
tawdrinesses1643434_ta_wdrinesses
unawarenesses1653734una_warenesses
valiantnesses1652724_valiantnesses
waywardnesses2351764_waywardnesses
awaynesses1644275__a_wa_ynesses
awkwardnesses2451825_awkwardnesses
backwardnesses2661305backwardnesses
blearinesses1446545__blearinesses
clearnesses13106155__clear_nesses
downwardnesses2291605downwardnesses
dwarfnesses1843295___dwarfnesses
earwitnesses1543785_earw_itnesses
flatnesses1337765__fl_a_tnesses
forwardnesses20123265_forwardnesses
frowardnesses20112895_frowardnesses
glarinesses1239515__gl_arinesses
haggardnesses1952255_haggardnesses
inwardnesses1654675__inwardnesses
laggardnesses1652395_laggardnesses
lukewarmnesses2361005lukewarmnesses
malapertnesses1881385_malapertnesses
outwardnesses1752615_outwardnesses
paltrinesses1445515_pal_trinesses
peartnesses1338745___peartnesses
pliantnesses1444455__pliantnesses
sallownesses1542745s_al_lownesses
saltinesses11311455s_al__tinesses
savagenesses1644225s_a_vagenesses
savorinesses1544615s_a_vorinesses
scalinesses1339325scal___inesses
scantnesses1376535s___cantnesses
scarinesses1339905s___carinesses
seaworthinesses2161435sea_worthinesses
selectnesses1446115s_el_ectnesses
semidarknesses2161295semidarknesses
shallownesses1951555shal_lownesses
sharpnesses1645235s___harpnesses
shortnesses1446795s___hortnesses
silentnesses1275445s_il_entnesses
silverinesses1643695s_ilverinesses
slacknesses1745245s__l_acknesses
slatinesses11311635s__l_atinesses
sleazinesses2145375s__leazinesses
slightnesses1654625s__lightnesses
sluggardnesses1761285sluggardnesses
smallnesses1344965smal___lnesses
solitarinesses1452975solitarinesses
sparenesses1339175s___parenesses
squarenesses2144975s__quarenesses
squatnesses2045215s__qua_tnesses
stablenesses1448105sta__blenesses
staginesses1238465st___aginesses
staidnesses1237195st___aidnesses
stalwarts1243815stalwart_____s
starchinesses1843215sta_rchinesses
statelinesses1344235sta_telinesses
staunchnesses1851465sta_unchnesses
steadinesses1346905st__eadinesses
stealthinesses1751955steal_thinesses
steaminesses1446225st__eaminesses
sternnesses1146635st___ernnesses
stillnesses1146735stil___lnesses
stiltednesses1454015stil_tednesses
stoutnesses1146975st___outnesses
straightnesses1872585straightnesses
streakinesses1743635st_reakinesses
strictnesses1445415st__rictnesses
stubbornnesses186805stubbornnesses
stylishnesses1843405styl_ishnesses
sultanesses1145565s_ulta__nesses
sultrinesses1245885s_ul_trinesses
swarthinesses1943455s___warthinesses
swartness1236115s___wartne_s_s
sweetnesses1445725s___weetnesses
swiftnesses1744505s___wiftnesses
tacitnesses1336325_ta__citnesses
talkinesses1537355_tal__kinesses
tallnesses1037475_tal___lnesses
tarrinesses11129085_ta__rrinesses
tartinesses111011505_t___artinesses
tautnesses10118285_t___autnesses
tawninesses1436155_ta_w_ninesses
tearinesses11311695_t__earinesses
untowardnesses1862335untowardnesses
unwarinesses1546155__unwarinesses
upwardnesses1843095__upwardnesses
vacantnesses1742975_va_cantnesses
warinesses131514525____warinesses
warmnesses15167355____warmnesses

Search took 7 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.376475242.0
2DLD Change Limit950241046.45314725.6
3Display Results1041040.0601733.3
 (SQL Overall)1786911046.88925938.6
 
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.