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

130 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
colonialnesses165305(None) 
colonialness1453462colonialne_s_s
colorfulnesses1993833colorfulnesses
cordialnesses1654573co_rdialnesses
clownishnesses2262274clownishnesses
colonialisms1674754colonial__isms
colonialists1484994colonial__ists
colonializes2354394colonial__izes
colorfastnesses2061304colorfastnesses
coltishnesses1845224col_tishnesses
coolnesses1237194co_o___lnesses
corninesses13410594co_rni__nesses
corporealnesses1961884corporealnesses
illogicalnesses1871664illogicalnesses
ironicalnesses1662584_ironicalnesses
localnesses1345854__lo_calnesses
logicalnesses1653194__logicalnesses
looninesses1197994lo_oni__nesses
mooninesses13127944mo_oni__nesses
palatialnesses1653384palatialnesses
venialnesses1555704__venialnesses
alonenesses1147215_alon__enesses
belongingnesses1961455belongingnesses
blondnesses1445545_blon__dnesses
bloodinesses1544275bloodi__nesses
blowinesses1635985_blowi__nesses
boninesses121111455__boni__nesses
bonninesses1337355bo_nni__nesses
bookishnesses2263685bo_okishnesses
boorishnesses1864315bo_orishnesses
boozinesses22175805bo_ozi__nesses
canninesses1368855c_anni__nesses
casualnesses1443785c__asualnesses
chillnesses1644725c___hillnesses
choicenesses1944675c_ho_icenesses
civilnesses1644855c__ivi_lnesses
clannishnesses1952985clannishnesses
cleannesses13135825c_l__eannesses
clearnesses13106155c_l__earnesses
cloddishnesses2152625cloddishnesses
cloistresses1452345c_lo_istresses
closenesses1347845c_lo__senesses
cloudinesses1545125c_lo_udinesses
cockinesses1947565co_cki__nesses
coercivenesses2165655coercivenesses
cohesivenesses2256205cohesivenesses
coldnesses1338425col____dnesses
colonialism1565435colonial__is_m
colonialist1376725colonial__is_t
colonialistic1773185colonial_istic
colonialize2254625colonial__ize_
colonialized2453635colonial__ized
colonials1147905colonial_____s
colonises112814015coloni_____ses
colonitises1345625coloni___tises
colorfulness1753825colorfulne_s_s
colorlessnesses1665095colorlessnesses
comelinesses1666405comeli__nesses
comfinesses1846915co_mfi__nesses
commonnesses18103185common___nesses
concisenesses1746595co_ncisenesses
contritenesses1655495contritenesses
convalesces1853125c__onval_esces
cordialness1444775co_rdialne_s_s
corkinesses1749215co_rki__nesses
corrosivenesses2094595corrosivenesses
cosinesses121012825c__osi__nesses
costivenesses1848165co_stivenesses
costlinesses1446255costli__nesses
cozinesses21179505c__ozi__nesses
criticalnesses1853155criticalnesses
cultishnesses1844565cul_tishnesses
cunningnesses1673245c_unningnesses
debonairnesses1771445debonairnesses
dolefulnesses1774845dol_efulnesses
dollishnesses1744375dol_lishnesses
dolorousnesses1555785dolorousnesses
doltishnesses1744615dol_tishnesses
donnishnesses1784115do_nnishnesses
downinesses1536145do_wni__nesses
essentialnesses1462645essentialnesses
eternalnesses1353695etern_alnesses
feloniousnesses1855155feloniousnesses
finicalnesses1853835__finicalnesses
floridnesses1654135_flori_dnesses
folkishnesses2343925fol_kishnesses
folksinesses1964065folksi__nesses
foolishnesses1944465fo_olishnesses
formalnesses1744485__formalnesses
gloominesses1544125gloomi__nesses
goofinesses1535965go_ofi__nesses
holinesses13511495hol__i__nesses
horninesses1459005ho_rni__nesses
initialnesses1395615_initialnesses
jollinesses1836725jol_li__nesses
kookinesses1435375ko_oki__nesses
loginesses11410325__logi__nesses
lonelinesses12146345__lonelinesses
lonenesses10311345__lon__enesses
longnesses1138505__lon__gnesses
loopinesses13116735lo_opi__nesses
lovingnesses1643675__lovingnesses
lyricalnesses1853105__lyricalnesses
materialnesses1653915materialnesses
moldinesses14138045mol_di__nesses
moodinesses14147645mo_odi__nesses
mournfulnesses1963425mournfulnesses
oozinesses19178025_o_ozi__nesses
ovalnesses1346055___o_valnesses
phoninesses1636455_phoni__nesses
pictorialnesses1962145pictorialnesses
poeticalnesses1853105poeticalnesses
politenesses1448595pol__itenesses
rationalnesses1452635ration_alnesses
roominesses1337435ro_omi__nesses
rootinesses1139525ro_oti__nesses
scornfulnesses1953205sco_rnfulnesses
solidnesses1238105sol__i_dnesses
sootinesses11410055so_oti__nesses
specialnesses1753865_specialnesses
stoninesses1138255_stoni__nesses
vocalnesses1645095__vo_calnesses
volatilenesses1754475volatilenesses
voluntarinesses1862155voluntarinesses
wolfishnesses2243735wol_fishnesses
womanishnesses2252825womanishnesses
woodinesses15127465wo_odi__nesses
woolinesses14157505wo_oli__nesses
woollinesses15113795woolli__nesses
woozinesses23175635wo_ozi__nesses

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.390458182.1
2DLD Change Limit950241306.48614650.6
3Display Results1301300.0931397.8
 (SQL Overall)1786911306.96925640.8
 
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.