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

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

50 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
goddesses124345(None) 
goddess1035262godde_s_s
goodnesses1236432goodnesses
oddnesses1136352_oddnesses
addresses1165633addresses
agednesses1237413agednesses
badnesses1239253badnesses
boldnesses1337233boldnesses
coldnesses1338423coldnesses
condenses12710133condenses
confesses1438623confesses
cordlesses1346303cordlesses
coynesses1437573coynesses
dresses83716173__dresses
eldresses1045673eldresses
fondnesses1437703fondnesses
gaynesses1336563gaynesses
geodesies1144593geodesies
giddinesses1435303giddinesses
gladnesses1236683gladnesses
godless938403godle_s_s
godlessly1443153godlessly
godlessness1355433godlessness
godlinesses1337123godlinesses
goldeyes1344483golde_yes
gonenesses11310253gonenesses
gorinesses11311553gorinesses
guesses8169373g__uesses
hostesses1247173hostesses
hotnesses1238903hotnesses
idlesses936003_idlesses
loesses7310033lo__esses
loudnesses1138433loudnesses
lownesses1236983lownesses
madnesses1239833madnesses
noblesses1146003noblesses
nownesses1236893nownesses
obsesses1036223_obsesses
ogresses938473_ogresses
oldnesses1037703oldnesses
oyesses1037333_o_yesses
poetesses1137233poetesses
possesses1046323possesses
rednesses10312313rednesses
redresses10410293redresses
sadnesses10310303sadnesses
undresses1039313undresses
voidnesses1436843voidnesses
votresses1236503votresses
woenesses1239133woenesses

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 Filter1786911486410.216827273.1
2DLD Change Limit148641506.34323433.9
3Display Results50500.0163125.0
 (SQL Overall)178691506.57527177.3
 
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.