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

106 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
livablenesses1812580(None) 
likablenesses1995411likablenesses
lovablenesses18115811lovablenesses
livableness1645902livablene_s_s
losablenesses1596042losablenesses
movablenesses20135622movablenesses
pliablenesses1756042pli_ablenesses
sizablenesses2445372sizablenesses
amiablenesses1756503amiablenesses
amicablenesses2055173amicablenesses
capablenesses1955433capablenesses
curablenesses17146953curablenesses
durablenesses16156543durablenesses
enviablenesses1965863enviablenesses
equablenesses2465463equablenesses
laudablenesses1754273laudablenesses
likableness1755323likablene_s_s
littlenesses1246073li_ttlenesses
livelinesses15145623liv_elinesses
livenesses13411053liv___enesses
lovableness1645593lovablene_s_s
nimblenesses1655983ni_mblenesses
notablenesses1546613notablenesses
pitiablenesses1855033pitiablenesses
potablenesses1746463potablenesses
provablenesses2154853provablenesses
reliablenesses1655783reli_ablenesses
stablenesses1448073_stablenesses
suitablenesses1655383suitablenesses
tenablenesses1546623tenablenesses
tunablenesses1555813tunablenesses
usablenesses1446713_usablenesses
violablenesses1984703violablenesses
visiblenesses1855293visiblenesses
voidablenesses2054693voidablenesses
admirablenesses2074324admirablenesses
adorablenesses1755414adorablenesses
advisablenesses21113924advisablenesses
alivenesses1448854aliv___enesses
availablenesses2063704availablenesses
bizarrenesses2451994bizarrenesses
civilnesses1644844civ_il_nesses
culpablenesses2053874culpablenesses
damnablenesses1954594damnablenesses
desirablenesses1855584desirablenesses
diversenesses1754074diversenesses
doublenesses1546484_doublenesses
ediblenesses1545784_ediblenesses
equitablenesses26104284equitablenesses
estimablenesses1954044estimablenesses
excitablenesses2664524excitablenesses
favorablenesses2354094favorablenesses
feeblenesses1745524_feeblenesses
femalenesses1746844fema_lenesses
ficklenesses2144134fi_cklenesses
habitablenesses2254014habitablenesses
halenesses13312034__ha_lenesses
humblenesses1944954_humblenesses
idlenesses1138024_i__dlenesses
ignoblenesses1653674ignoblenesses
immovablenesses2493784immovablenesses
inanenesses1149514_ina_nenesses
iratenesses11411404_ira_tenesses
irritablenesses1755004irritablenesses
lamenesses12610564l__a_menesses
largenesses1247554l__argenesses
latenesses10413354l__a_tenesses
laughablenesses2183114laughablenesses
levelnesses1445534lev_el_nesses
likenesses1449534li___kenesses
limbernesses1643154li_mbernesses
lissomenesses1453474lissomenesses
litenesses10513004li___tenesses
lithenesses1447304li__thenesses
lividnesses1545014liv__idnesses
livingnesses1643654liv_ingnesses
localnesses1345844loca_l_nesses
losableness1346034losablene_s_s
lovelinesses15125334lov_elinesses
malenesses12312204__ma_lenesses
miserablenesses1954644miserablenesses
movableness1855734movablene_s_s
noblenesses1348054__noblenesses
ovalnesses1346044_ova_l_nesses
palatablenesses1973914palatablenesses
palenesses12312654__pa_lenesses
pliableness1546594pli_ablene_s_s
privatenesses1855284priva_tenesses
readablenesses1755184readablenesses
removablenesses2264234removablenesses
savagenesses1644224sava_genesses
simplenesses1645614si_mplenesses
singlenesses1346094si_nglenesses
sizableness2265584sizablene_s_s
sociablenesses1855084sociablenesses
stalenesses11311084_sta_lenesses
thinkablenesses2463004thinkablenesses
unstablenesses1656004unstablenesses
vaguenesses1544814__vaguenesses
valuablenesses1954674valuablenesses
variablenesses1965454variablenesses
veritablenesses2055034veritablenesses
vilenesses13310214__v_ilenesses
vitalnesses1456244vita_l_nesses
volublenesses1854554volublenesses
workablenesses2354414workablenesses

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.1431249587.4
2DLD Change Limit950241065.76316488.6
3Display Results1061060.0631682.5
 (SQL Overall)1786911065.96929936.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.