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

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
loathsomenesses20112111loathsomenesses_
loathsomeness1862273loathsomene_s_s_
toothsomenesses2061903toothsomenesses_
lightsomenesses2161824lightsomenesses_
lonesomenesses1653794lo_nesomenesses_
longsomenesses1763084lo_ngsomenesses_
awesomenesses1853385__awesomenesses_
fearsomenesses1953195fea_rsomenesses_
footsorenesses1792225foot_sorenesses_
gamesomenesses1962725_gamesomenesses_
gladsomenesses1892385gla_dsomenesses_
handsomenesses2062705_handsomenesses_
lissomenesses1453475l__issomenesses_
loathnesses1445865loath____nesses_
noisomenesses1554245no__isomenesses_
toilsomenesses1662705to_ilsomenesses_
toothsomeness1861945toothsomene_s_s_
wearisomenesses2062415wearisomenesses_
worrisomenesses2062275worrisomenesses_
coarsenesses1447246coa_rs__enesses_
fulsomenesses1853126__fulsomenesses_
gruesomenesses1753076_gruesomenesses_
hoarsenesses1545606hoa_rs__enesses_
irksomenesses1953196__irksomenesses_
lamenesses12610566l_a____menesses_
latenesses10413366l_at____enesses_
lightsomeness1982016lightsomene_s_s_
lithenesses1447316l_ith___enesses_
loaminesses1358456loa____minesses_
lonesomeness1454116lo_nesomene_s_s_
longsomeness1553156lo_ngsomene_s_s_
loosenesses1147246lo____osenesses_
loutishnesses1644996loutis__hnesses_
obtusenesses1445066_obtus__enesses_
orthogeneses1665066_orth_ogene_ses_
otiosenesses1245706_o_t_iosenesses_
pathogeneses1854586_path_ogene_ses_
tiresomenesses1653346_tiresomenesses_
wholesomenesses2361916wholesomenesses_
winsomenesses1854046__winsomenesses_

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 Filter178691658740.330541487.9
2DLD Change Limit65874404.89013471.2
3Display Results40400.0301333.3
 (SQL Overall)178691405.25034036.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.