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

141 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
blondest1141924(None) 
blandest113811041blandest
blindest11609091blindest
blondes104213161blondes_
blankest14439062blankest
blendes104713682blendes_
blonde94813292blonde__
blonder104011942blonde_r
blondish1476172blondish
blondness1234962blondness
blonds95213342blond_s_
bloodiest1236662bloodiest
blowiest1337922blowiest
bluntest1036552bluntest
boldest102613062b_oldest
boniest93318992b_oniest
broadest1138572broadest
fondest11312402_fondest
longest84114952_longest
loudest839932_loudest
baddest112611143b_addest
baldest102313533b_aldest
barniest104815053barniest
bendiest112311983b_endiest
blackest16269303blackest
blades95221253bl_ades_
blander103715163blande_r
blandish1497003blandish
blandness1235973blandness
blanket134313093blanke_t
blankets14356503blankets
bleakest1436283bleakest
blende95413443blende__
blended114710713blende_d
blender104613843blende_r
blenders115210993blenders
blends96012883blend_s_
blest76431723bl___est
blinded114810023blinde_d
blinder103912983blinde_r
blinders113911143blinders
blindgut1242453blindgut
blindness1235343blindness
blinds95111613blind_s_
blithest1338083blithest
blockiest1736363blockiest
blokes123813883blo_kes_
blond85618373blond___
blondine1137153blondine
blondines1246153blondines_
blooded11379803bloode_d
bloodies11310163bloodies_
bloodless1234513bloodless
bloodlust1243333bloodlust
bloods94614843blood_s_
bloomiest1335853bloomiest
blotless10347153blotless
blottiest11286833blottiest
blouses94014463blouses_
blousiest1136313blousiest
blowsiest1435323blowsiest
blowziest2343673blowziest
bluest84016483bl__uest
bluffest1664643bluffest
blunder103813153blunde_r
blunders113911343blunders
blunges104212223blunges_
bodes84935103b_o_des_
boldness1136973boldness
bolides10515073bolides_
bonded104719953b_onde_d
bonder95324783b_onde_r
bonders104120663b_onders
bondless1148813b_ondless
bonds86126843b_ond_s_
bones76446533b_on_es_
boneset9316433b_on_eset
boneyest1347843b_oneyest
bonnes85621453b_onnes_
bonnet85524633b_onne_t
bonnets94812803b_onnets
bonniest10310773bonniest
bonzes175116103b_onzes_
bookrest1436493bookrest
boomiest122711843boomiest
boonies93422483boonies_
boonless10328353boonless
booziest19379263booziest
boxiest163711983b_oxiest
briniest102812323briniest
bronzes183510403bronzes_
bronziest2035813bronziest
broodiest1237823broodiest
brownest1398893brownest
browniest14207123browniest
bundist10310193b_undist
cloddiest1334633cloddiest
clones84526563clon_es_
closest94312533clo_sest
cloudiest1235583cloudiest
coldest102514763_coldest
congest104618773_congest
contest93523233_contest
damndest1276003damndest
darndest1067223darndest
durndest1065763durndest
eldest72912683el__dest
gladdest11145843gladdest
glandes95413833glandes_
goldest92411173_goldest
gooniest93213003gooniest
grandest10311573grandest
honest94822423_hon_est
kindest12311503_kindest
lankest112714113_lankest
lewdest1136283_lewdest
liniest73321153_liniest
lodes66436913_lo_des_
logiest82515543_logiest
longes75925573_longes_
looniest83313253looniest
loosest75811563_loosest
lowest93915593_lo_west
luniest73516993_luniest
modest93818453_mo_dest
mondes94322353_mondes_
moondust1144013moondust
mooniest103014173mooniest
oddest81710863__oddest
oldest72114093__oldest
phoniest132811533phoniest
proudest1138943proudest
roundest9310473roundest
slowest10168713slo_west
solidest9310383solidest
sondes74922873_sondes_
soonest7415593soon_est
soundest9510973soundest
stoniest8413543stoniest
toniest73218903_toniest
wrongest1236733wrongest

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621417.18620339.8
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.40524131.1
 
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.