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

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
dazedness2011496(None) 
datedness1187751datedness
mazedness2194571mazedness
agedness1036682_agedness
dazednesses2245152dazednesses
fadedness1445612fadedness
jadedness1844692jadedness
nakedness1445042nakedness
acidness1136723_acidness
adaptedness1553113adaptedness
aridness939223_aridness
avidness1246113_avidness
badness1039573ba__dness
baldness1137043ba_ldness
bareness10912813bare_ness
baseness10910943base_ness
brazenness2142883brazenness
cageyness1543483cageyness
daffiness1634843daffiness
daftness1235533da_ftness
dailiness1038673dailiness
dailyness1343643dailyness
dampness1336073da_mpness
dankness13256693da_nkness
dapperness1543153dapperness
darkness13247343da_rkness
datednesses1357893datednesses
dateless9259963date_less
deadness1039233d_eadness
deedless10318253d_eedless
deepness1136443d_eepness
direness9311303dire_ness
dizziness1834183dizziness
doggedness1443513doggedness
doneness9411513done_ness
dopeyness1543473dopeyness
doziness18228553doz_iness
dueness82310123d_ue_ness
eagerness1046263eagerness
elatedness1146033elatedness
eyedness1245103_eyedness
fixedness2043713fixedness
gameness112810693game_ness
haleness11312623hale_ness
handedness1545903handedness
hardness122411083ha_rdness
haziness20248513haz_iness
jaggedness2042853jaggedness
jazziness2432843jazziness
lameness102612673lame_ness
lateness82614073late_ness
laziness17239983laz_iness
madness10310073ma__dness
maleness10312313male_ness
markedness1744023markedness
mateyness1444473mateyness
mazednesses2345403mazednesses
maziness19239543maz_iness
notedness1047323notedness
paleness10312983pale_ness
peakedness1744863peakedness
rabidness12145263rabidness
raggedness1344153raggedness
rapidness12155473rapidness
rareness81112853rare_ness
redness82012443__redness
sacredness1344543sacredness
sadness8310613sa__dness
safeness11239633safe_ness
sageness92111983sage_ness
sameness102712683same_ness
saneness82313723sane_ness
sidedness1146783sidedness
tameness102411253tame_ness
tiredness1036933tiredness
validness13125363validness
vapidness15144423vapidness
vexedness2043863vexedness
waeness102512783wa_e_ness

Search took 8 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.1561145455.1
2DLD Change Limit148641797.37320160.2
3Display Results79790.0461717.4
 (SQL Overall)178691797.57523589.6
 
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.