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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
blondness123496(None) 
blandness1235971blandness
blindness1235341blindness
aloneness957312aloneness
blankness1544672blankness
blondes104213162blond_e_s
blondest11419242blond_est
blondines1246152blondine_s
blondnesses1445542blondnesses
bloodiness1344352bloodiness
bloodless1234512bloodless
blowiness1435622blowiness
bluntness1144342bluntness
boldness1136972b_oldness
bondless1148812b_ondless
boniness102211802b_oniness
boundness1235942boundness
broadness1256662broadness
fondness1237212_fondness
loneness8512092_loneness
longness938552_longness
loudness937012_loudness
algidness1144273algidness
aloofness1242493aloofness
badness1039573b__adness
baldness1137043b_aldness
bandiness122310243b_andiness
blackness1735663blackness
blandest113811043bland_est
blandnesses1446623blandnesses
bleakness1543593bleakness
blenders115210993blend_ers
blendes104713683blend_e_s
blinders113911143blind_ers
blindest11609093blind_est
blindnesses1446183blindnesses
blonde94813293blond_e__
blonder104011943blond_e_r
blondine1137153blondine__
blondined1343483blondine_d
blondish1476173blond_ish
blonds95213343blond___s
bloodies11310163bloodie_s
bloodiest1236663bloodiest
bloomless1342963bloomless
blotless10347153blo_tless
blueness1038213bl_ueness
bluffness1742503bluffness
blunders113911343blund_ers
bonders104120663b_ond_ers
boneless10310213b_oneless
bonnes85621453b_on_ne_s
bonnets94812803b_on_nets
bonniness1136733bonniness
boonless10328353boon_less
booziness20135613booziness
boundless1235183boundless
boxiness17247813b_oxiness
brandless1236123brandless
brininess1138203brininess
broodiness1344653broodiness
broodless1235033broodless
brownness1444343brownness
closeness1137613closeness
cloudiness1344113cloudiness
cloudless1243153cloudless
coldness1137953_coldness
doneness9411513_doneness
floridness1443773floridness
fluidness1344293fluidness
gladness1036153gl_adness
glandless1134163glandless
goneness9310763_goneness
goodness1036253_goodness
grandness1138303grandness
ironness836953iron_ness
kindness13236653_kindness
landless94011173_landless
lankness12237043_lankness
lewdness1254173_lewdness
loginess9310163_loginess
looniness9137573looniness
lordless9277483_lordless
lornness836493_lornness
lostness837683_lostness
lowness1037813_lo_wness
mooniness11157863mooniness
oddness935313__oddness
oldness836403__oldness
oneness7512143__oneness
phoniness1436303phoniness
planeness1138153planeness
proneness11310443proneness
proudness1246693proudness
roundness1047013roundness
slowness1135013slo_wness
solidness1036903solidness
soundness1036963soundness
stoniness938343stoniness
voidness1235553_voidness
wrongness1344513wrongness

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.436409841.7
2DLD Change Limit1486411017.36020195.8
3Display Results1011010.0502020.0
 (SQL Overall)1786911017.84622774.8
 
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.