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

40 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
loathsomenesses2011211(None) 
loathsomeness1862272loathsomene_s_s
toothsomenesses2061902toothsomenesses
lightsomenesses2161823lightsomenesses
lonesomenesses1653793lo_nesomenesses
longsomenesses1763083lo_ngsomenesses
awesomenesses1853384__awesomenesses
fearsomenesses1953194fea_rsomenesses
footsorenesses1792224foot_sorenesses
gamesomenesses1962724_gamesomenesses
gladsomenesses1892384gla_dsomenesses
handsomenesses2062704_handsomenesses
lissomenesses1453474l__issomenesses
loathnesses1445864loath____nesses
noisomenesses1554244no__isomenesses
toilsomenesses1662704to_ilsomenesses
toothsomeness1861944toothsomene_s_s
wearisomenesses2062414wearisomenesses
worrisomenesses2062274worrisomenesses
coarsenesses1447245coa_rs__enesses
fulsomenesses1853125__fulsomenesses
gruesomenesses1753075_gruesomenesses
hoarsenesses1545605hoa_rs__enesses
irksomenesses1953195__irksomenesses
lamenesses12610565l_a____menesses
latenesses10413365l_at____enesses
lightsomeness1982015lightsomene_s_s
lithenesses1447315l_ith___enesses
loaminesses1358455loa____minesses
lonesomeness1454115lo_nesomene_s_s
longsomeness1553155lo_ngsomene_s_s
loosenesses1147245lo____osenesses
loutishnesses1644995loutis__hnesses
obtusenesses1445065_obtus__enesses
orthogeneses1665065_orth_ogene_ses
otiosenesses1245705_o_t_iosenesses
pathogeneses1854585_path_ogene_ses
tiresomenesses1653345_tiresomenesses
wholesomenesses2361915wholesomenesses
winsomenesses1854045__winsomenesses

Search took 5 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 Filter178691658740.343520965.0
2DLD Change Limit65874404.11016027.7
3Display Results40400.0133076.9
 (SQL Overall)178691404.46640011.4
 
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.