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

225 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
compactnesses215300(None) 
compactness1953302compactne_s_s
completenesses2053993completenesses
complexnesses26112723complexnesses
correctnesses1754213correctnesses
apartnesses1346824__apartnesses
campinesses1737114camp__inesses
comelinesses1666404com_elinesses
comfinesses1846914com__finesses
commonnesses18103184com_monnesses
compacters18247034compact_e__rs
compactest1845044compact_e_s_t
compasses1547394compa____sses
composednesses2152284composednesses
compresses1647774comp___resses
conductresses1861924conductresses
corruptnesses1752844corruptnesses
covertnesses1746334co_vertnesses
exactnesses2044344__exactnesses
inexactnesses2252914inexactnesses
intactnesses1444574_intactnesses
packnesses1856634___packnesses
pastnesses12910514___pastnesses
patnesses111611794___pa_tnesses
pompousnesses1955464pompousnesses
promptnesses1843634promp__tnesses
smartnesses1337144_sm_artnesses
spacinesses1538104__spacinesses
womannesses1644394wom_a_nnesses
abjectnesses2352565_abjectnesses
abstractnesses1862295abstractnesses
actresses1137935____actresses
adeptnesses1444835adep__tnesses
amplenesses1585705_amp_lenesses
aptnesses11168995____aptnesses
blacknesses1944995__blacknesses
bumpinesses17126375bump__inesses
caginesses13310945c___aginesses
cakinesses16310615c___akinesses
calmnesses1436845c___almnesses
canonesses1238425c___anonesses
capablenesses1955455c_apablenesses
casualnesses1443785casua_lnesses
cattinesses13129705c___attinesses
chancinesses1945035c_hancinesses
charinesses1639565c__harinesses
chastenesses1746315c__hastenesses
chattinesses1755155c__hattinesses
cheapnesses18104025c_hea_pnesses
chicnesses1745215c__hic_nesses
choicenesses1944675c_hoicenesses
choppinesses2143355chop_pinesses
cleannesses13135825c_lea_nnesses
clearnesses13106155c_lea_rnesses
coarsenesses1447245co_arsenesses
coatdresses1443945co__atdresses
cockinesses1947565co__ckinesses
cohostesses1652555co_host_esses
coldnesses1338425co___ldnesses
collectednesses2062595collectednesses
colorfastnesses2061305colorfastnesses
coltishnesses1845225coltishnesses
combativenesses2464155combativenesses
compacted18297365compact____ed
compacter17257885compact____er
compactible2153655compact_ible_
compactions1946545compact__ions
compactors18256255compact___ors
compacts16368905compact_____s
companies15311805compa__n__ies
compartmented2261865compartmented
compartments2094335compartme_nts
compassed1645545compa____ssed
compatibles19134145compa_t_ibles
competences1956375comp_et_ences
competencies2064975comp_etencies
complacences1953015complac__ences
complacencies2062645complacen_cies
completeness1854635completenes_s
complexness2453105complexne_s_s
compressed1745845comp___ressed
computereses18162785comp_utereses
computerises18224975comp_uterises
comradelinesses2061405comradelinesses
concisenesses1746595concisenesses
concretenesses1854165concretenesses
connectednesses2063355connectednesses
contactees14136005contact_e__es
contrarinesses1674245contrarinesses
contritenesses1655495contritenesses
coolnesses1237195co___olnesses
copartnered1651375co_partne_red
copartners1443575co_partne__rs
copiousnesses1747815copiousnesses
cordialnesses1654575cordialnesses
corkinesses1749225co__rkinesses
corninesses13410605co__rninesses
correctness1553815correctne_s_s
cosinesses121012825co___sinesses
costivenesses1848165costivenesses
costlinesses1446255co_stlinesses
countesses1248845co__unt_esses
courtlinesses1544465courtlinesses
coynesses1437575co____ynesses
cozinesses21179505co___zinesses
craftinesses1746385c__raftinesses
crassnesses1246655c__rassnesses
crazinesses2237935c__razinesses
creakinesses1845995c_reakinesses
creaminesses1646135c_reaminesses
culpablenesses2053905culpablenesses
currentnesses1552995currentnesses
curtnesses1238375c___urtnesses
daftnesses1436385___daftnesses
dampnesses1535605damp___nesses
deaconesses1445655__deaconesses
directnesses1595285_directnesses
distantnesses1453835distantnesses
dopeynesses1744025do_p_eynesses
dopinesses13159725do_p__inesses
dumpinesses16126255dump__inesses
emptinesses1545995_emp_tinesses
erectnesses1347475__erectnesses
expertnesses2144845_expertnesses
fastnesses1389085___fastnesses
fatnesses121710465___fa_tnesses
femalenesses1746865fem_alenesses
flatnesses1337765__fla_tnesses
foaminesses1658075fo__aminesses
foppishnesses2343395foppishnesses
formalnesses1744485forma_lnesses
forwardnesses20123265forwardnesses
gastnesses11129155___gastnesses
greatnesses1247795_grea_tnesses
hoarinesses14310225ho__arinesses
homelinesses1765365hom_elinesses
homesicknesses2561595homesicknesses
homeynesses1984815hom__eynesses
hominesses15510875hom___inesses
hotnesses1238905ho____tnesses
humanenesses1744255hum_anenesses
humannesses1643865hum_a_nnesses
humpinesses18106245hump__inesses
impishnesses1944295_impishnesses
implicitnesses2061815_implicitnesses
impurenesses16164435_impurenesses
inaptnesses1385635__inaptnesses
incorrectnesses1961665incorrectnesses
ineptnesses1396385inep__tnesses
instantnesses1354065instantnesses
jumpinesses22125345jump__inesses
lacinesses12312125___lacinesses
limpidnesses1743625limp_idnesses
limpnesses14116655limp___nesses
loaminesses1358455lo__aminesses
loathnesses1445865lo__athnesses
localnesses1345855lo_ca_lnesses
logicalnesses1653195logicalnesses
loopinesses13116735loop__inesses
lostnesses1049305lo___stnesses
lumpinesses15107115lump__inesses
lumpishnesses2043475lumpishnesses
madnesses1239835__m_a_dnesses
malenesses12312225__m_alenesses
maltinesses13310235__m_altinesses
matinesses12314545__m_atinesses
mattresses1245435__m_attresses
mazinesses2139925__m_azinesses
mealinesses13310975__mealinesses
meannesses12128165__mea_nnesses
meatinesses13311985__meatinesses
meetnesses1237455__m_eetnesses
moistnesses1347155__moistnesses
mootnesses1237155__m_ootnesses
mopinesses14139125mo_p__inesses
muchnesses1744715__m_uchnesses
neatnesses10310015__nea_tnesses
oblatenesses1475775_oblatenesses
opaquenesses2352965_o_paquenesses
opennesses1246315_o_p_ennesses
oratresses1045495_o_ra_tresses
ornatenesses1257305_ornatenesses
ovalnesses1346055_o_va_lnesses
overtnesses1448715_o_vertnesses
palenesses12312665___palenesses
pastinesses13911725___pastinesses
peartnesses1338745__peartnesses
perfectnesses2053355perfectnesses
pertnesses12310315___pertnesses
piquantnesses2452035piquantnesses
pliantnesses1444455_pliantnesses
racinesses12313515___racinesses
raptnesses1248525___raptnesses
robustnesses1443805ro_bustnesses
ropinesses121311025ro_p__inesses
saltnesses10310165___saltnesses
scantnesses1376535__scantnesses
selectnesses1446115_selectnesses
sempstresses1552205semp_stresses
simplenesses1645625simp_lenesses
slacknesses1745245__slacknesses
smallnesses1344965_sm_allnesses
soapinesses1339715so__apinesses
softnesses1337605so___ftnesses
sombernesses1643615som_bernesses
soppinesses1566845so_p_pinesses
sparenesses1339175__sparenesses
spicinesses1547105__spicinesses
squatnesses2045215_squa_tnesses
straitnesses1246215_straitnesses
strictnesses1445415_strictnesses
swartnesses1436715__swartnesses
tacitnesses1336325___tacitnesses
tartnesses101110715___tartnesses
tautnesses10118285___tautnesses
temptresses1543595temp__tresses
unaptnesses1395525__unaptnesses
vacantnesses1742975_vacantnesses
valiantnesses1652725valiantnesses
vastnesses13128205___vastnesses
vocalnesses1645095vo_ca_lnesses
whatnesses1635735__wha_tnesses
wimpinesses1835635wimp__inesses
wimpishnesses2343585wimpishnesses
womanlinesses1843145womanlinesses

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 Filter1786911247900.390458182.1
2DLD Change Limit1247902258.31315011.4
3Display Results2252250.1401607.1
 (SQL Overall)1786912258.84320207.1
 
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.