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

110 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
sugariest103814(None) 
scariest101615952s_cariest
smeariest1138122smeariest
sudaries9312752sudaries_
sugarier937392sugarie_r
sugarless1043672sugarless
sultriest938652sultriest
angaries9314393angaries_
angriest9310253ang_riest
auguries947933auguries_
bleariest1158853bleariest
buggiest123410363bug_giest
burriest102911213bu_rriest
chariest13315513_chariest
dreariest10229123dreariest
fuggiest13228813fug_giest
furriest112910793fu_rriest
gamiest102816233__gamiest
glariest92012533_glariest
goriest82218743__goriest
hoariest11312883_hoariest
hungriest1344543hungriest
leariest83117853_leariest
muggiest12228533mug_giest
pugarees11195493pugarees_
puggiest12219223pug_giest
puggries12166383puggries_
quaggiest2044173quaggiest
quakiest2138583qu_akiest
queasiest1844313queasiest
queaziest2743243queaziest
saggiest102812723sag_giest
sagiest82617993s__agiest
salaries8319593salaries_
sarkiest123615073s__arkiest
savoriest1246623savoriest
scaliest101714403s_caliest
scarcest12169173s_carcest
scarriest11188403scarriest
seamiest102715423s_eamiest
searest73322023s_ear_est
shadiest121711283s_hadiest
shaggiest14156903shaggiest
shakiest151910943s_hakiest
shaliest111415063s_haliest
sharpest1339153s_harpest
shoaliest1238513shoaliest
sitarist8315283sitari_st
slaggiest11157713slaggiest
slatiest82616273s_latiest
sleaziest1836063sleaziest
smarmiest1335913s_marmiest
smartest10310183s_martest
snaggiest11126683snaggiest
snakiest122110553s_nakiest
snarkiest13207643s_narkiest
snarliest91810213s_narliest
sneakiest13176843sneakiest
sneeriest939313sneeriest
soapiest102412853s_oapiest
soggiest102711643sog_giest
sorriest8413883s_orriest
spaciest122310903s_paciest
sparest94616433s_par_est
sparkiest15188103s_parkiest
sparriest11198793sparriest
sparsest1048823s_parsest
spheriest1438383spheriest
spiriest102513463s_piriest
spriest92718653s__priest
squarest17338223squar_est
squeakiest2342793squeakiest
staggiest11148263staggiest
stagiest91613413s_tagiest
starkest1239723s_tarkest
starriest9159773starriest
steadiest1038523steadiest
steamiest1138413steamiest
strawiest1237223strawiest
suavest10310623su_a_vest
suckiest143314113su_ckiest
sudsiest939623su_dsiest
sugarbush1551583sugarbush
sugarcoat1253693sugarcoat
sugared938583sugar_e_d
sugarer837323sugar_e_r
sugarers936303sugar_ers
sugaring1039053sugari_ng
sugars7312423sugar__s_
suggest9310863sug__gest
sulkiest124212503su_lkiest
summaries13118183summaries_
summarist13116763summari_st
summeriest1476083summeriest
sundries9312023sundries_
sunniest82712913su_nniest
superbest1349963superbest
surest65026763su__r_est
surfiest112414433su_rfiest
surgeries10311363surgeries_
surliest82416913su_rliest
sweatiest1238423sweatiest
teariest82417263_teariest
ugliest8410153_ug_liest
unwariest1246033unwariest
vagaries12310293vagaries_
vuggiest13216923vug_giest
vulgarest1343773vulgar_est
wariest105122503__wariest
weariest112914793_weariest

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 Limit1486411106.95321378.0
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.