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

168 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
steadfastnesses188871steadfastnesses_
steadfastness176853steadfastne_s_s_
stalwartnesses1751295st_alwartnesses_
steadinesses1346905stead___inesses_
colorfastnesses2061306colorfastnesses_
dreadfulnesses19193796dreadf_ulnesses_
earnestnesses1353666__earnestnesses_
fastnesses1389086_____fastnesses_
headlessnesses17137066_headlessnesses_
headmistresses2061186_headmistresses_
lightfastnesses2261436lightfastnesses_
pleasantnesses1661566plea_santnesses_
seamlessnesses1446976s_eamlessnesses_
seamstresses1352256s_ea__mstresses_
sedatenesses1346966s_e_d_atenesses_
selfishnesses1844046s_e_lfishnesses_
stealthinesses1751956stea_lthinesses_
steaminesses1446226ste___aminesses_
straightnesses1872586stra_ightnesses_
straitnesses1246216st___raitnesses_
tearfulnesses1645536_tearf_ulnesses_
adeptnesses1444837___ad_eptnesses_
adroitnesses1344137___adroitnesses_
adultnesses1244837___ad_ultnesses_
apartnesses1346827___a_partnesses_
augustnesses1352697___augustnesses_
beadinesses1449567_bead___inesses_
bearishnesses1844847_bea_rishnesses_
benefactresses216827_benefactresses_
caddishnesses2043377__caddishnesses_
daftnesses1436387____d_aftnesses_
deadlinesses1446227_dead__linesses_
deadnesses1238947_dead____nesses_
deafnesses1436227_dea_f___nesses_
deftnesses1436817_de__f__tnesses_
dreamfulnesses20183697dreamf_ulnesses_
dreamlessnesses17104537dreamlessnesses_
dwarfishnesses2492137_dwarfishnesses_
earwitnesses1543787__ea_rwitnesses_
easinesses10314447__e___asinesses_
endlessnesses1356767__endlessnesses_
eternalnesses1353697ete_rna_lnesses_
exactnesses2044347__e__xactnesses_
faddishnesses2143247__faddishnesses_
fatnesses121710467_____fa_tnesses_
fearfulnesses1945317_fearf_ulnesses_
fearlessnesses1666747_fearlessnesses_
fiendishnesses2172477fiend_ishnesses_
freakishnesses2452657frea_kishnesses_
gastnesses11129157_____gastnesses_
gradualnesses1552897_gradua_lnesses_
greasinesses1347067gre___asinesses_
greatnesses1247797gre___a_tnesses_
headinesses1539847_head___inesses_
heedfulnesses20124107_heedf_ulnesses_
heedlessnesses17136227_heedlessnesses_
inexactnesses2252917ine__xactnesses_
jealousnesses2056327_jealous_nesses_
leadennesses1354577_lead__ennesses_
leafinesses1437877_lea_f__inesses_
maladroitnesses1881007maladroitnesses_
neatnesses10310017_ne___a_tnesses_
needfulnesses17134097_needf_ulnesses_
needlessnesses14115697_needlessnesses_
oafishnesses1844777__oa_fishnesses_
pastnesses12910517_____pastnesses_
peartnesses1338747_pe___artnesses_
perfectnesses2053357_pe_rfectnesses_
queasinesses2144177que___asinesses_
raffishnesses2243227__raffishnesses_
readablenesses1755207_readablenesses_
readinesses12611277_read___inesses_
reddishnesses1873587_re_ddishnesses_
sadnesses10310307s__ad____nesses_
safenesses1349377s__a_f__enesses_
saltnesses10310167s_____altnesses_
saplessnesses1347277s__aplessnesses_
sassinesses999327s__a__ssinesses_
savagenesses1644227s__a_vagenesses_
scantnesses1376537s____cantnesses_
seaminesses13310757s_e___aminesses_
seasicknesses1873077s_ea_sicknesses_
seductresses1552047s_e_d_uctresses_
seedinesses1259207s_eed___inesses_
selectnesses1446117s_e__lectnesses_
selflessnesses15115997s_elflessnesses_
selfnesses1335897s_e_lf___nesses_
selfsamenesses1892147s_elfsamenesses_
semidarknesses2161297s_emidarknesses_
sempstresses1552207s_e__mpstresses_
separatenesses1654267s_eparatenesses_
seriousnesses1249907s_erious_nesses_
sexlessnesses1846747s_e_xlessnesses_
shadinesses1538647s_had___inesses_
shadowinesses2052147s_had_owinesses_
sheepishnesses2153017she_epishnesses_
slavishnesses1843687s_la_vishnesses_
sleazinesses2145377sle___azinesses_
sleeplessnesses1554687sleeplessnesses_
slendernesses1453137slend__ernesses_
smartnesses1337147s____martnesses_
snappishnesses2052267s_nappishnesses_
sneakinesses1645907sne___akinesses_
sniffishnesses2272207s_niffishnesses_
softnesses1337607s___of__tnesses_
sparsenesses1345807s_pa__rsenesses_
specialnesses1753867spe_cia_lnesses_
speciousnesses17146907specious_nesses_
speedinesses1545597speed___inesses_
squarishnesses2552447squa_rishnesses_
squatnesses2045217s___qua_tnesses_
squeamishnesses2871227squea_mishnesses_
stablenesses1448107st_a__blenesses_
staginesses1238467st____aginesses_
staidnesses1237197st____aidnesses_
stalenesses11311107st____alenesses_
stalwartness1551507st_alwartne_s_s_
starchinesses1843217st_a_rchinesses_
starknesses1545887st____arknesses_
statelessnesses1355867statelessnesses_
statelinesses1344237st_a_telinesses_
staunchnesses1851467st_a_unchnesses_
steadfast1343017steadfast_______
steadfastly186717steadfast_____ly
steadiness1146707stead___ine_s_s_
steelinesses1246727ste___elinesses_
steepnesses1345927ste____epnesses_
sterlingnesses1553147ste_rlingnesses_
sternnesses1146637ste____rnnesses_
stewardesses1651477ste__wa_rdesses_
stiffnesses1743597st__if__fnesses_
stodginesses1443947st_od__ginesses_
stoutnesses1146977st____outnesses_
strandednesses1652827stra_ndednesses_
strangenesses1454967stra__ngenesses_
streakinesses1743637st__reakinesses_
strenuousnesses1453737strenuous_nesses_
strictnesses1445417st___rictnesses_
studiednesses1552837st_ud_iednesses_
studiousnesses1475877st_udiousnesses_
stuffinesses1843297st__uf_finesses_
sturdinesses1345797sturd___inesses_
stylelessnesses1674717stylelessnesses_
stylishnesses1843407st__ylishnesses_
swainishnesses1952327s_wainishnesses_
swartnesses1436717s____wartnesses_
sweatinesses1546917swe___atinesses_
sweetnesses1445727swe____etnesses_
swiftnesses1744507s__wif__tnesses_
tacitnesses1336327_t_a__citnesses_
tartnesses101110717_t____artnesses_
tastinesses111110787_t____astinesses_
tautnesses10118287_t____autnesses_
teachablenesses2283847_teachablenesses_
tearinesses11311697_te___arinesses_
tediousnesses1447777_te_diousnesses_
tendernesses1345077_tend__ernesses_
tensenesses1147617_te___nsenesses_
tenuousnesses1357057_tenuous_nesses_
tersenesses1149047_te___rsenesses_
testinesses111210327_te____stinesses_
uneasinesses1246627une___asinesses_
unsteadinesses1553067unstead___inesses_
vacantnesses1742977__va_cantnesses_
valiantnesses1652727__valiantnesses_
vastnesses13128207_____vastnesses_
yeastinesses1545567_ye___astinesses_
zealousnesses2256267_zealous_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.373479064.3
2DLD Change Limit950241687.72012308.8
3Display Results1681680.1261333.3
 (SQL Overall)1786911688.21921741.2
 
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.