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

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

79 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
lovesicknesses236159(None) 
homesicknesses2561592homesicknesses
lovesickness2161492lovesickne_s_s
lovelinesses15125333loveli__nesses
airsicknesses1952224_airsicknesses
cohesivenesses2256204cohesivenesses
greensicknesses2261474greensicknesses
homesickness2361754homesickne_s_s
livelinesses15145634liveli__nesses
liverishnesses2063024liverishnesses
lonelinesses12146344loneli__nesses
lonesomenesses1653794lonesomenesses
lousinesses111210324lo_usi__nesses
lovelessnesses1646994lovelessnesses
lovelornnesses1761404lovelornnesses
lovingnesses1643674lov__ingnesses
seasicknesses1873074_seasicknesses
sicknesses1636764____sicknesses
adhesivenesses2155055adhesivenesses
aversivenesses2056565_aversivenesses
bossinesses12117355bo_ssi__nesses
cheesinesses1765375cheesi__nesses
comelinesses1666405comeli__nesses
cosinesses121012825co__si__nesses
covertnesses1746335cove__rtnesses
covetousnesses1955225covetousnesses
divisivenesses2154965divisivenesses
dovishnesses1944465dov__ishnesses
evasivenesses1957145_evasivenesses
feverishnesses2382885feverishnesses
flowerinesses1942905floweri__nesses
folksinesses1964065folksi__nesses
foreignnesses1752755fore_ignnesses
genericnesses1652745generic_nesses
glossinesses1254495glo_ssi__nesses
governesses1546725gove___rnesses
heartsicknesses2471185heartsicknesses
homelinesses1765365homeli__nesses
horsinesses1439555ho_rsi__nesses
invasivenesses2056025invasivenesses
lavishnesses1844775lav__ishnesses
leerinesses11119485l_eeri__nesses
levelnesses1445555leve___lnesses
lifelikenesses2152395lifelikenesses
livenesses13411075live____nesses
lividnesses1545025liv__i_dnesses
livingnesses1643665liv__ingnesses
loaminesses1358455lo_ami__nesses
loftinesses1437925lo_fti__nesses
logicalnesses1653195lo__gicalnesses
loginesses11410325lo__gi__nesses
lonenesses10311345lone____nesses
longsomenesses1763085longsomenesses
looninesses1197995lo_oni__nesses
loopinesses13116735lo_opi__nesses
loosenesses1147245lo_os__enesses
lopsidednesses1852525lo_psidednesses
lordlinesses1345175lordli__nesses
lostnesses1049305lo__s__tnesses
loutishnesses1644995lo_utishnesses
lovablenesses18115845lov_ablenesses
loveliness1345305loveli__ne_s_s
lowlinesses1436685lo_wli__nesses
mossinesses12117465mo_ssi__nesses
mousinesses13129835mo_usi__nesses
movelessnesses1846745movelessnesses
noisinesses1139485no_isi__nesses
nosinesses101411325no__si__nesses
obesenesses1346765_obes__enesses
overimpresses2062765_overimpresses
overtnesses1448715_ove__rtnesses
poeticalnesses1853105po_eticalnesses
quicknesses2643755___quicknesses
rosinesses101213145ro__si__nesses
slicknesses1745195___slicknesses
slovenlinesses1751765slove_nlinesses
thicknesses2043915___thicknesses
unlovelinesses1752465unloveli__nesses
venialnesses1555705__venialnesses

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.360496363.9
2DLD Change Limit95024795.59316989.8
3Display Results79790.0631254.0
 (SQL Overall)178691796.01629702.6
 
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.