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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
lovablenesses1811581(None) 
livablenesses18125801livablenesses
losablenesses1596041losablenesses
movablenesses20135621movablenesses
likablenesses1995412likablenesses
lovableness1645592lovablene_s_s
notablenesses1546612notablenesses
potablenesses1746462potablenesses
provablenesses2154852provablenesses
adorablenesses1755413adorablenesses
amiablenesses1756503amiablenesses
capablenesses1955433capablenesses
curablenesses17146953curablenesses
doublenesses1546483do_ublenesses
durablenesses16156543durablenesses
enviablenesses1965863enviablenesses
equablenesses2465463equablenesses
immovablenesses2493783immovablenesses
laudablenesses1754273laudablenesses
livableness1645903livablene_s_s
localnesses1345843loca_l_nesses
losableness1346033losablene_s_s
lovelinesses15125333lov_elinesses
movableness1855733movablene_s_s
noblenesses1348053no__blenesses
ovalnesses1346043_ova_l_nesses
pliablenesses1756043pliablenesses
removablenesses2264233removablenesses
sizablenesses2445373sizablenesses
sociablenesses1855083sociablenesses
stablenesses1448073_stablenesses
tenablenesses1546623tenablenesses
tunablenesses1555813tunablenesses
usablenesses1446713_usablenesses
violablenesses1984703violablenesses
voidablenesses2054693voidablenesses
volublenesses1854553volublenesses
workablenesses2354413workablenesses
advisablenesses21113924advisablenesses
amicablenesses2055174amicablenesses
coarsenesses1447234co_arsenesses
culpablenesses2053874culpablenesses
damnablenesses1954594damnablenesses
ediblenesses1545784_ediblenesses
enjoyablenesses2773514enjoyablenesses
favorablenesses2354094favorablenesses
feeblenesses1745524_feeblenesses
femalenesses1746844fema_lenesses
forciblenesses2154174forciblenesses
halenesses13312034__ha_lenesses
hoarsenesses1545594ho_arsenesses
honorablenesses2064174honorablenesses
horriblenesses1953884horriblenesses
humblenesses1944954_humblenesses
ignoblenesses1653674ignoblenesses
lamenesses12610564l__a_menesses
largenesses1247554l__argenesses
latenesses10413354l__a_tenesses
laughablenesses2183114laughablenesses
levelnesses1445534lev_el_nesses
likableness1755324likablene_s_s
littlenesses1246074l_ittlenesses
livelinesses15145624liv_elinesses
livenesses13411054liv___enesses
loaminesses1358444lo_a_minesses
loathnesses1445854lo_a_thnesses
lonelinesses12146344lo_nelinesses
lonenesses10311344lo___nenesses
loosenesses1147234lo__osenesses
lordlinesses1345154lo_rdlinesses
lovelessnesses1646984lov_elessnesses
lovingnesses1643674lov_ingnesses
lowlinesses1436684lo__wlinesses
malenesses12312204__ma_lenesses
memorablenesses2154814memorablenesses
nimblenesses1655984_nimblenesses
notableness1347614notablene_s_s
opaquenesses2352954_opaquenesses
palatablenesses1973914palatablenesses
palenesses12312654__pa_lenesses
pitiablenesses1855034pitiablenesses
potableness1547184potablene_s_s
provableness1955504provablene_s_s
readablenesses1755184readablenesses
reliablenesses1655784reliablenesses
savagenesses1644224sava_genesses
slovenlinesses1751764slovenlinesses
solenesses10412704so___lenesses
stalenesses11311084_sta_lenesses
suitablenesses1655384suitablenesses
unstablenesses1656004unstablenesses
vaguenesses1544814__vaguenesses
valuablenesses1954674valuablenesses
variablenesses1965454variablenesses
vilenesses13310214__v_ilenesses
visiblenesses1855294visiblenesses
vocalnesses1645084voca_l_nesses
volatilenesses1754454volatilenesses
wobblinesses1943054wo_bblinesses
womanlinesses1843134womanlinesses

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 Limit950241005.53317174.0
3Display Results1001000.0601666.7
 (SQL Overall)1786911005.71631261.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.