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

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

135 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
ghastlinesses174274(None) 
ghostlinesses1742491ghostlinesses
beastlinesses1563422beastlinesses
ghastliness1542642ghastline_s_s
gristlinesses1443992gristlinesses
hastinesses141210692_hast_inesses
chastenesses1746313chast_enesses
chattinesses1755153cha_ttinesses
costlinesses1446253_costlinesses
gassinesses1197973g_as_sinesses
gastnesses11129143g_ast__nesses
ghostliness1542563ghostline_s_s
glassinesses1255243glas_sinesses
grislinesses1345823gris_linesses
gustinesses12139523g_ust_inesses
nastinesses111110743_nast_inesses
pastinesses13911713_past_inesses
shapelinesses1843413shapelinesses
tastinesses111110783_tast_inesses
yeastinesses1545563yeast_inesses
antsinesses1148754__antsinesses
artinesses10815214__art_inesses
artsinesses1138714__artsinesses
ashinesses1339164__as_hinesses
battinesses13169454_ba_ttinesses
beastliness1343334beastline_s_s
brassinesses1346064bras_sinesses
brattinesses1466264bra_ttinesses
bustinesses131310094_bust_inesses
cattinesses13129704_ca_ttinesses
chancinesses1945034cha_ncinesses
charinesses1639564cha__rinesses
chillinesses1744984ch_illinesses
classinesses1366114clas_sinesses
courtlinesses1544464courtlinesses
craftinesses1746384craft_inesses
crustinesses14137634crust_inesses
dailinesses1249494_da_ilinesses
deadlinesses1446224dea_dlinesses
draftinesses1645754draft_inesses
dustinesses121110354_dust_inesses
earlinesses11311044_ea_rlinesses
earthinesses1545824_earthinesses
earthlinesses1643914_earthlinesses
easinesses10314444_eas__inesses
fastnesses1389084_fast__nesses
fattinesses14118974_fa_ttinesses
faultinesses1545184_faultinesses
feistinesses1555894feist_inesses
flashinesses18124864flas_hinesses
frostinesses1546534frost_inesses
fustinesses14129784_fust_inesses
gabbinesses1634904g_a_bbinesses
gaminesses13410464g_a__minesses
gaudinesses1337854g_a_udinesses
gauzinesses2136044g_a_uzinesses
gawkinesses1935634g_a_wkinesses
gentlenesses1366014g_entlenesses
ghastliest1443444ghastli_e_s_t
glarinesses1239514gla__rinesses
glazinesses2136404gla__zinesses
glossinesses1254494glos_sinesses
godlinesses1337124g__odlinesses
goutinesses1239974g_out_inesses
gracilenesses1655164gracilenesses
graininesses1346594gra_ininesses
grapinesses1438574gra__pinesses
greasinesses1347044greas__inesses
gristliness1264004gristline_s_s
grittinesses1345844g_rittinesses
growlinesses1644724g_rowlinesses
growthinesses2042604growthinesses
guiltinesses1345114guilt_inesses
gushinesses15127024g_us_hinesses
gutsinesses12128154g__utsinesses
hairinesses14198944_ha_irinesses
halenesses13312044_ha__lenesses
halfnesses1636264_ha__lfnesses
hamminesses1835774_ha_mminesses
handinesses151410274_ha_ndinesses
happinesses1876164_ha_ppinesses
hardinesses151110214_ha_rdinesses
hastiness122410884_hast_ine_s_s
hazinesses2239224_ha__zinesses
healthinesses1942964healthinesses
heartinesses1548004heart_inesses
heftinesses1737134_heft_inesses
hillinesses1458504_h_illinesses
holinesses13511494_h__olinesses
homelinesses1765364_homelinesses
huskinesses18136534_hus_kinesses
lustinesses11910424_lust_inesses
maltinesses13310234_malt_inesses
manlinesses13910194_ma_nlinesses
massinesses12128694_mas_sinesses
masterlinesses1673524_masterlinesses
matinesses12314544_ma_t_inesses
mealinesses13310974mea__linesses
meatinesses13311984mea_t_inesses
mistinesses131310624_mist_inesses
mustinesses131010414_must_inesses
nattinesses11119324_na_ttinesses
paltrinesses1445514_paltrinesses
pastnesses12910514_past__nesses
portlinesses1446994_portlinesses
priestlinesses1652724priestlinesses
raspinesses1338014_ras_pinesses
rustinesses11911554_rust_inesses
saintlinesses1344364saintlinesses
saltinesses11311454_salt_inesses
sassinesses999324_sas_sinesses
scalinesses1339324sca__linesses
scantinesses1437314scant_inesses
shabbinesses1953434sha_bbinesses
shadinesses1538644sha__dinesses
shadowinesses2052144shadowinesses
shagginesses1743964sha_gginesses
shakinesses1837614sha__kinesses
shiftinesses18105244shift_inesses
sightlinesses1743864sightlinesses
slatinesses11311634sla_t_inesses
statelinesses1344234statelinesses
swarthinesses1943454swarthinesses
tartinesses111011504_tart_inesses
tattinesses11128944_ta_ttinesses
testinesses111210324_test_inesses
thirstinesses1642584thirst_inesses
trashinesses1546114tras_hinesses
trustinesses12116984trust_inesses
vastnesses13128204_vast__nesses
washinesses1737264_was_hinesses
waspinesses1636704_was_pinesses
weaklinesses1944484wea_klinesses
wealthinesses1942624wealthinesses
whatnesses1635734wha_t__nesses

Search took 6 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.1231452772.4
2DLD Change Limit950241354.98319069.6
3Display Results1351350.0801687.5
 (SQL Overall)1786911355.18634456.4
 
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.