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

103 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
clubbiest153427(None) 
chubbiest1843751chubbiest
clubbier1434832clubbie_r
clubbiness1642992clubbiness
clubbish1743812clubbi_sh
clumpiest1535352clumpiest
clumsiest1335392clumsiest
clunkiest1535162clunkiest
cobbiest14118522c_obbiest
crabbiest1535622crabbiest
crumbiest1536252crumbiest
cubbies133312882c_ubbies_
flabbiest1644212flabbiest
globbiest1444022globbiest
grubbiest1434252grubbiest
knubbiest1752622knubbiest
nubbiest12117312_nubbiest
scrubbiest1643162scrubbiest
slobbiest1345092slobbiest
snubbiest1345072snubbiest
stubbiest1345482stubbiest
tubbiest12117292_tubbiest
bluesiest1135693bluesiest
blurbist1245493blurbi_st
blurriest1155153blurriest
bubbies103913513_bubbies_
bubbliest1254423_bubbliest
cabbies133115163c_abbies_
chubbier1733893chubbie_r
chubbiness1942553chubbiness
chuffiest2044403chuffiest
chummiest1834643chummiest
chunkiest1835263chunkiest
clammiest1535743clammiest
clankiest1536673clankiest
classiest11309553classiest
clayiest1337923cl_ayiest
cliffiest1743953cliffiest
clingiest1257133clingiest
cliquiest2044093cliquiest
cloddiest1334633cloddiest
cloggiest1334723cloggiest
cloudiest1235583cloudiest
clubbed14307453clubb_e_d
clubber13319593clubb_e_r
clubbers14378583clubb_ers
clubbing15266513clubbi_ng
clubfeet1543793clu_bfeet
couthiest1439403couthiest
cruddiest1334453cruddiest
crumbliest1643903crumbliest
crummiest1545563crummiest
crustiest112410053crustiest
cubbish1635803c_ubbi_sh
cubist104214443c_u_bi_st
cuppiest1448203c_uppiest
curdiest112511393c_urdiest
curliest102713123c_urliest
curviest13309673c_urviest
cushiest133411043c_ushiest
daubiest1138233dau_biest
fluffiest1434093fluffiest
flukiest15248063flu_kiest
flutiest112610883flu_tiest
fubsiest13258413_fubsiest
gabbiest1337273_gabbiest
glibbest1343683glibb_est
gluiest839773glu__iest
glumpiest1434953glumpiest
grabbiest1435323grabbiest
hubbies143211563_hubbies_
kludgiest1543153kludgiest
klutziest2242803klutziest
knobbiest1752883knobbiest
lambiest122410193_lambiest
limbiest12258893_limbiest
lobbies113612463_lobbies_
luckiest143011443_luckiest
lumpiest1239263_lumpiest
luniest73516993_lu_niest
lustiest82914493_lustiest
nobbiest12117773_nobbiest
nubbliest1354363_nubbliest
pluckiest1735293pluckiest
plumiest122110293plu_miest
plummiest1544973plummiest
plunkiest1535503plunkiest
plushiest1466403plushiest
ribbiest1237583_ribbiest
rubbies114114113_rubbies_
rubbliest1354693_rubbliest
rubiest92914423_ru_biest
scabbiest1534923scabbiest
shabbiest1635333shabbiest
shrubbiest1742353shrubbiest
sludgiest1135813sludgiest
slummiest1335673slummiest
slushiest1267043slushiest
sluttiest937343sluttiest
snobbiest1354963snobbiest
squabbiest2342863squabbiest
stubbliest1453343stubbliest
webbiest1535353_webbiest

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.423422437.4
2DLD Change Limit1486411037.48319863.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.95222471.2
 
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.