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

94 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
strangenesses145495(None) 
strandednesses1652812strandednesses
strangeness1246092strangene_s_s
stringinesses14124532stringinesses
ranginesses121210113__ranginesses
sagenesses11510823s__a_genesses
sanenesses10412693s__an_enesses
savagenesses1644223sava_genesses
serenenesses12117093seren_enesses
slanginesses1346963s_langinesses
springinesses16104063springinesses
stablenesses1448073st_ablenesses
staginesses1238463st_a_ginesses
stalenesses11311083st_a_lenesses
stinginesses1375963st_inginesses
straightnesses1872583straightnesses
straitnesses1246203stra_itnesses
tanginesses1278883_t_anginesses
averagenesses1755004avera_genesses
boringnesses15105014boring_nesses
bravenesses1647944_bra_venesses
cragginesses1644504_cragginesses
crankinesses1846144_crankinesses
curablenesses17146954curablenesses
daringnesses1464834daring_nesses
durablenesses16156544durablenesses
franknesses1845604_fran_knesses
grandnesses1348114_gran_dnesses
gravenesses1548164_gra_venesses
humanenesses1744234human_enesses
inanenesses1149514_inan_enesses
insanenesses1246874insan_enesses
iratenesses11411404_ira_tenesses
largenesses1247554__largenesses
manginesses1499594__manginesses
ornatenesses1257284_ornatenesses
pangeneses1346374__pangene_ses
parageneses1446204para_gene_ses
planenesses1349034_plan_enesses
pronenesses1379254_pron_enesses
raggednesses1543854__raggednesses
randinesses121311204__randinesses
ranknesses1438094__ran_knesses
rarenesses10313094__ra_renesses
safenesses1349374s__a_fenesses
samenesses12410854s__a_menesses
sandinesses12911394s__andinesses
scantinesses1437314s_cantinesses
scantnesses1376534s_can_tnesses
scarcenesses1644494s_carcenesses
scrappinesses1952294scrappinesses
scrawninesses1842424scrawninesses
sedatenesses1346944seda_tenesses
servilenesses1646264servilenesses
shagginesses1743964s_hagginesses
singlenesses1346094s__inglenesses
sizablenesses2445374sizablenesses
sorenesses101313484sor___enesses
sparenesses1339174s_pa_renesses
sparsenesses1345804s_parsenesses
sponginesses1544774s_ponginesses
sprucenesses1694614spr_ucenesses
squarenesses2144934squa_renesses
staidnesses1237194st_a_idnesses
starchinesses1843214starchinesses
starknesses1545884st_a_rknesses
staunchnesses1851464staunchnesses
steadinesses1346904stea_dinesses
steaminesses1446224stea_minesses
sterlingnesses1553144sterling_nesses
sternnesses1146634stern__nesses
stodginesses1443944st_odginesses
stoninesses1138254st_on_inesses
strandedness1453694strandedne_s_s
straplesses1353284stra__plesses
streakinesses1743624streakinesses
strictnesses1445404str_ictnesses
stringencies1553524stringen_cies
stringiness1245264stringine_s_s
stuntednesses1453924st_untednesses
suavenesses1448394s_ua_venesses
supinenesses1445994supin_enesses
surenesses101212204sur___enesses
swankinesses1944784s_wankinesses
tamenesses1259964_t_a_menesses
tensenesses1147594_t_ensenesses
thingnesses1545174_thing_nesses
transgresses1354154_transgresses
trashinesses1546114_trashinesses
trendinesses1346324_trendinesses
trignesses1188214_tr_ig_nesses
tritenesses11710354_tr_itenesses
truenesses1039314_tr__uenesses
wrongnesses1544924_wrong_nesses

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.1231452772.4
2DLD Change Limit95024946.72014140.5
3Display Results94940.0631492.1
 (SQL Overall)178691946.90625874.7
 
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.