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

146 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
crabbiest153562(None) 
grabbiest1435321grabbiest
cabbies133115162c_abbies_
chubbiest1843752chubbiest
clubbiest1534272clubbiest
cobbiest14118522c_obbiest
crabbier14326802crabbie_r
craftiest1436912craftiest
craggiest13116522craggiest
crampiest15268612crampiest
crankiest1538822crankiest
crappiest15267262crappiest
crawliest14187402crawliest
craziest19319922cra_ziest
crumbiest1536252crumbiest
drabbest13295662drabb_est
flabbiest1644202flabbiest
gabbiest1337272_gabbiest
grubbiest1434252grubbiest
rabbies113416052_rabbies_
ribbiest1237582_ribbiest
scabbiest1534912scabbiest
scrabbliest1742482scrabbliest
scrubbiest1643162scrubbiest
shabbiest1635322shabbiest
babiest114414753_ba_biest
brabbles11349753brabbles_
braggiest13116783braggiest
brainiest11209723brainiest
brakiest143912243bra_kiest
brambliest1643773brambliest
branniest11199383branniest
brashiest14359853brashiest
brassiest11369713brassiest
brattiest1148103brattiest
brawliest14177193brawliest
brawniest14197103brawniest
cabbie122913353c_abbie__
cagiest102916433c_a_giest
cakiest133215663c_a_kiest
cambist13312113c_ambi_st
campiest142212133c_ampiest
canniest10313363c_anniest
cattiest103016333c_attiest
chaffiest2045413chaffiest
chalkiest1837083chalkiest
chanciest1638373chanciest
chariest13315503cha_riest
charriest1438253charriest
chattiest1448203chattiest
clammiest1535733clammiest
clankiest1536663clankiest
classiest11309543classiest
clayiest1337913cla_yiest
coaliest10316223coa_liest
crabbed14388873crabb_e_d
crabber133810733crabb_e_r
crabbers14358753crabb_ers
crabbily1744343crabbi_ly
crabbing15287933crabbi_ng
crabmeat1445483cra_bmeat
crabwise1543613crabwi_se
crackliest1844883crackliest
crambes1339963cramb_es_
cramboes1436543cramboes_
crankest1438143cra_nkest
crannies10313013crannies_
crappies142911153crappies_
crassest103411523cra_ssest
crazies183413853cra_zies_
creakiest15238593creakiest
creamiest13248933creamiest
creasiest11229943creasiest
creepiest1337063creepiest
crepiest12310383cr_epiest
crimpiest15237183crimpiest
crispiest13197423crispiest
croakiest15167173croakiest
croupiest1337063croupiest
cruddiest1334453cruddiest
crumbliest1643903crumbliest
crummiest1545563crummiest
crustiest112410053crustiest
crybabies1842723crybabies_
cubbies133312883c_ubbies_
daubiest1138233_daubiest
drabbet12319573drabb_e_t
drabbets13294823drabb_ets
drabbles13308523drabbles_
draffiest1644363draffiest
draftiest1335943draftiest
draggiest12126413draggiest
drawliest13166243drawliest
fabbest1438033_fabb_est
globbiest1444023globbiest
grabbier13316653grabbie_r
grabbles13339893grabbles_
grainiest10188993grainiest
grapiest112211923gra_piest
grassiest10309513grassiest
knobbiest1752883knobbiest
knubbiest1752623knubbiest
lambiest122410183_lambiest
marbliest1336763marbliest
nobbiest12117773_nobbiest
nubbiest12117313_nubbiest
orangiest1038463orangiest
orbiest9312413or__biest
rabbet103818653_rabb_e_t
rabbets11279423_rabb_ets
rabbins112811343_rabbins_
rabbis102613163_rabbi_s_
rabbit102914563_rabbi__t
rabbits11299863_rabbits_
rabbles113517973_rabbles_
rabies85226023_ra_bies_
raciest92820013_ra_ciest
rainiest81214923_rainiest
rammiest12299933_rammiest
randiest93418773_randiest
rangiest93115983_rangiest
raspiest10311273_raspiest
rattiest83516113_rattiest
rubbies114114113_rubbies_
rubbliest1354693_rubbliest
rubiest92914423_r_ubiest
scrabbles15206283scrabbles_
scraggiest1444363scraggiest
scrappiest1644153scrappiest
scrawliest1553813scrawliest
scrawniest1543483scrawniest
shrubbiest1742353shrubbiest
slobbiest1345083slobbiest
snobbiest1354963snobbiest
snubbiest1345073snubbiest
squabbiest2342853squabbiest
stubbiest1345483stubbiest
swabbies15115713swabbies_
tabbies112913503_tabbies_
trampiest13227893trampiest
trashiest123110633trashiest
tubbiest12117293_tubbiest
wabbliest16274963_wabbliest
webbiest1535353_webbiest
wrathiest1536973wrathiest
yabbies14279643_yabbies_

Search took 10 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.453394461.4
2DLD Change Limit1486411469.25016069.3
3Display Results1461460.0632317.5
 (SQL Overall)1786911469.76618297.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.