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

211 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
greensicknesses2261471greensicknesses_
greensickness2061523greensickne_s_s_
greenishnesses1882964green_ishnesses_
genericnesses1652745g_eneric_nesses_
greasinesses1347045gr_easi__nesses_
greedinesses1446465gree_di__nesses_
greennesses1247035green____nesses_
homesicknesses2561595home_sicknesses_
lovesicknesses2361595love_sicknesses_
seasicknesses1873075__seasicknesses_
airsicknesses1952226__airsicknesses_
breezinesses2343946bree_zi__nesses_
cheesinesses1765376chee_si__nesses_
creepinesses1645256cree_pi__nesses_
defensivenesses2255786defensivenesses_
dressinesses1245526dr_essi__nesses_
expensivenesses27105496expensivenesses_
extensivenesses2595286extensivenesses_
franticnesses1843676fr_antic_nesses_
geekinesses1635816g_ee_ki__nesses_
genuinenesses1475306g__enuinenesses_
graininesses1346596grain_i__nesses_
graphicnesses2151846gr_aphic_nesses_
greenishness1653156green_ishne_s_s_
gruesomenesses1753076grue_somenesses_
heartsicknesses2471186heartsicknesses_
intensivenesses1856286intensivenesses_
offensivenesses2464576offensivenesses_
pensivenesses1849026__pensivenesses_
queenlinesses2252296queenli__nesses_
recessivenesses1955816_recessivenesses_
reedinesses1259566_ree_di__nesses_
retentivenesses1896406_retentivenesses_
sicknesses1636766_____sicknesses_
trendinesses1346326tr_endi__nesses_
adhesivenesses2155057adhe_sivenesses_
agreeablenesses1873367agree_ablenesses_
agribusinesses1751667agribusi__nesses_
artsinesses1138717ar__tsi__nesses_
attentivenesses1874697attentivenesses_
aversivenesses2056567_aversivenesses_
beefinesses1675957_bee_fi__nesses_
beerinesses1398927_bee_ri__nesses_
braininesses1446557brain_i__nesses_
brassinesses1346067br_assi__nesses_
brawninesses1744707brawn_i__nesses_
breathinesses1853677breathi__nesses_
brininesses1338987br_in_i__nesses_
brisknesses1745587br____isknesses_
cheekinesses2164207chee_ki__nesses_
cheerinesses1765827chee_ri__nesses_
cleanlinesses1553887cleanli__nesses_
cohesivenesses2256207cohe_sivenesses_
crankinesses1846147cr_anki__nesses_
creakinesses1845997cr_eaki__nesses_
creaminesses1646137cr_eami__nesses_
creativenesses1967037cr_eativenesses_
decisivenesses2056767_decisivenesses_
delusivenesses1856547_delusivenesses_
densenesses1247367__dens__enesses_
derisivenesses1857237_derisivenesses_
dreaminesses1545717dr_eami__nesses_
drearinesses1347447dr_eari__nesses_
drowsinesses1644387dr_owsi__nesses_
easinesses10314447___easi__nesses_
eerinesses10612607__ee_ri__nesses_
elusivenesses1697707__elusivenesses_
entirenesses1249667___entirenesses_
erectnesses1347477er_e___ctnesses_
erosivenesses1648317__erosivenesses_
essentialnesses1462647essentialnesses_
evasivenesses1957147__evasivenesses_
excessivenesses2675147excessivenesses_
exoticnesses2142687__exotic_nesses_
expansivenesses2794527expansivenesses_
feelingnesses1753517_fee_lingnesses_
fiendishnesses2172477_fiendishnesses_
finickinesses2272067__fin_ickinesses_
fleetingnesses1872807flee_tingnesses_
franknesses1845607fr_an___knesses_
freakinesses1945597fr_eaki__nesses_
freakishnesses2452657fr_eakishnesses_
freenesses1339877free_____nesses_
freshnesses1746107fr_e_s__hnesses_
friendlinesses1852217frien_dlinesses_
gamesomenesses1962727game_somenesses_
gassinesses1197977g__assi__nesses_
gelidnesses1355987g__e_li_dnesses_
gemminesses1634977g__emmi__nesses_
genericness1472907g_eneric_ne_s_s_
generousnesses1556947g_enerousnesses_
genteelnesses1453537g__enteelnesses_
gentilesses1243497g__enti__lesses_
gentlenesses1366017g__en_tlenesses_
germinesses1437887g__ermi__nesses_
glassinesses1255247g_lassi__nesses_
gleefulnesses1764257glee__fulnesses_
glossinesses1254497g_lossi__nesses_
gracilenesses1655167gr__acilenesses_
grandiosenesses1781857gr_andiosenesses_
grandnesses1348117gr_an___dnesses_
grapinesses1438577gr__api__nesses_
graspingnesses1852057gr_aspingnesses_
greasiness1156547gr_easi__ne_s_s_
greatnesses1247797gr_e___atnesses_
greediness1245837gree_di__ne_s_s_
greenbackers2152027greenback_e__rs_
greenbackisms2416847greenback__isms_
greenfinches2161047greenfi__n_ches_
greenness1046797green____ne_s_s_
greenockites1961257green_ock__ites_
greensick1642877greensick_______
greenskeeper1961137greens__k_eepe_r
greenskeepers2061137greens__k_eepers
greenstones1253727greens_ton___es_
greynesses1446327gr_e____ynesses_
grievousnesses1864867grie_vousnesses_
griminesses14167557gr____iminesses_
grimnesses13106537gr____i_mnesses_
grislinesses1345827gr__is_linesses_
gristlinesses1443997gr__istlinesses_
grittinesses1345847gr_itti__nesses_
grogginesses1544077gr_oggi__nesses_
grossnesses1146717gr__os__snesses_
grotesquenesses2561517grotesquenesses_
grouchinesses1942657grouchi__nesses_
growlinesses1644727gr_owli__nesses_
growthinesses2042607growthi__nesses_
grubbinesses1743287gr_ubbi__nesses_
grumpinesses1743667gr_umpi__nesses_
gutsinesses12128157g__utsi__nesses_
homesickness2361757home_sickne_s_s_
identicalnesses1882427_identicalnesses_
immensenesses1762997immens__enesses_
intensenesses1356057intens__enesses_
inventivenesses21136257inventivenesses_
ironicalnesses1662587ir_on_icalnesses_
keennesses1445327_keen____nesses_
leerinesses11119487_lee_ri__nesses_
lovesickness2161497love_sickne_s_s_
meeknesses1644807_mee____knesses_
messinesses1297517__messi__nesses_
needinesses1258107_nee_di__nesses_
newsinesses1436327__newsi__nesses_
nicenesses12310357____n_icenesses_
obsessivenesses18104447obsessivenesses_
orderlinesses1453397orderli__nesses_
ornerinesses1246577orne_ri__nesses_
peevishnesses2143477_pee_vishnesses_
pervasivenesses2355207pervasivenesses_
pleasingnesses1752837_pleasingnesses_
prankishnesses2353207pr_ankishnesses_
preachinesses2043757preachi__nesses_
precisenesses1756287pr_e_cisenesses_
preppinesses1544887pr_eppi__nesses_
presentnesses1554427pr_e_sentnesses_
prettinesses1447547pr_etti__nesses_
priestlinesses1652727prie_stlinesses_
prissinesses1355957pr_issi__nesses_
prolificnesses2151167prolific_nesses_
prosinesses13310857pr__osi__nesses_
queasinesses2144177_queasi__nesses_
quicknesses2643757____quicknesses_
raininesses11310487_rain_i__nesses_
rancidnesses1544887_r_anci_dnesses_
randinesses121311207_r_andi__nesses_
ranginesses121210117_r_angi__nesses_
ranknesses1438097_r_an___knesses_
reactivenesses1956927_reactivenesses_
readinesses12611277_r_eadi__nesses_
recentnesses1465377_recen___tnesses_
receptivenesses22106057_receptivenesses_
reclusivenesses2055287_reclusivenesses_
reconditenesses1863157_reconditenesses_
recursivenesses2055347_recursivenesses_
reddishnesses1873587_r_eddishnesses_
remissnesses1344957_r_e_missnesses_
repulsivenesses2064897_repulsivenesses_
requisitenesses2463517_requisitenesses_
resentfulnesses1883747_resentfulnesses_
resistivenesses1755767_resistivenesses_
restivenesses1679447_r_estivenesses_
retiringnesses1552487_retiringnesses_
richnesses1537807_r____ichnesses_
rosinesses101213147_r__osi__nesses_
runninesses11137697_r_unni__nesses_
runtinesses111210967_r_unti__nesses_
seasickness1752667__seasickne_s_s_
seedinesses1259207_see_di__nesses_
seemlinesses1445227_seemli__nesses_
sensiblenesses1555257__sensiblenesses_
serenenesses12117117seren___enesses_
sheepishnesses2153017shee_pishnesses_
sleeknesses1545277slee____knesses_
sleepinesses1445677slee_pi__nesses_
slicknesses1745197____slicknesses_
speedinesses1545597spee_di__nesses_
splendidnesses1871717splendi_dnesses_
steelinesses1246727stee_li__nesses_
sweepingnesses2052067swee_pingnesses_
teemingnesses1653067_tee_mingnesses_
tensenesses1147617__tens__enesses_
thicknesses2043917____thicknesses_
trickinesses1845227tr____ickinesses_
tricksinesses1962437tricksi__nesses_
tweedinesses1643617twee_di__nesses_
uneasinesses1246627_uneasi__nesses_
venialnesses1555707__ven_ialnesses_
weedinesses1557077_wee_di__nesses_
weepinesses1646137_wee_pi__nesses_
wheezinesses2742867whee_zi__nesses_

Search took 10 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.1101624463.6
2DLD Change Limit950242119.03310519.7
3Display Results2112110.1561352.6
 (SQL Overall)1786912119.29919216.2
 
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.