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

212 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
sparkiest1518810(None) 
sarkiest123615071s_arkiest
snarkiest13207641snarkiest
sparkliest1644581sparkliest
sparriest11198791sparriest
barkiest144115152_barkiest
larkiest123713322_larkiest
pawkiest17277892_pawkiest
perkiest143313242_perkiest
porkiest143513712_porkiest
scariest101615952scar_iest
scarriest11188402scarriest
shakiest151910942sha_kiest
skankiest12145712skankiest
smarmiest1335912smarmiest
smirkiest1535192smirkiest
snakiest122110552sna_kiest
snarliest91810212snarliest
spaciest122310902spa_ciest
sparest94616432spar__est
sparkier14298032sparkie_r
sparkish17276972sparki_sh
sparkles143210492sparkles_
sparklet143110592sparkle_t
sparklets15275842sparklets
sparsest1048822spar_sest
spikiest14259542sp_ikiest
spiriest102513462spir_iest
spookiest15156402spookiest
sportiest111711032sportiest
spriest92718652sp_r_iest
spunkiest15166572spunkiest
stalkiest1347912stalkiest
starkest1239722stark_est
starriest9159772starriest
swankiest16136212swankiest
artiest73121993__artiest
balkiest144112453_balkiest
barmiest125212783_barmiest
barniest104815053_barniest
beakiest143313463bea_kiest
brakiest143912243bra_kiest
cakiest133215663_ca_kiest
chalkiest1837093chalkiest
chariest13315513char_iest
charriest1438263charriest
clankiest1536673clankiest
corkiest143114793_corkiest
crankiest1538823crankiest
darkest122512623_dark_est
darkies124015753_darkies_
darkliest1435163_darkliest
dorkiest133111253_dorkiest
earliest82415243_earliest
flakiest153210553fla_kiest
forkiest153812303_forkiest
gawkiest16327313_gawkiest
glariest92012533glar_iest
gnarliest10186553gnarliest
hardiest123416343_hardiest
heartiest12311103heartiest
hoariest11312883hoar_iest
jerkiest19328113_jerkiest
lakiest113517273_la_kiest
lankiest122912503_lankiest
lardiest93813893_lardiest
leakiest123212803lea_kiest
leariest83117853lear_iest
marliest102415183_marliest
mirkiest142910253_mirkiest
murkiest143210263_murkiest
nearliest949363nearliest
oakiest112913923_oa_kiest
paciest112917813_pa_ciest
paliest93021613_pa_liest
palliest102814643_palliest
palmiest123212033_palmiest
pappiest112611123_pappiest
paries84742513_par_ies_
parries93925843_parries_
parties93230863_parties_
pastiest103319553_pastiest
peakiest143513003_peakiest
pearliest1139363pearliest
peckiest162711393_peckiest
peskiest142610163_peskiest
pickiest162712593_pickiest
pockiest163412053_pockiest
pokiest133314913_p_okiest
porkies133416493_porkies_
porniest103214313_porniest
priest84125423_p_r_iest
punkiest149312663_punkiest
pursiest102812123_pursiest
purtiest102414113_purtiest
quackiest2435183quackiest
quakiest2138583qua_kiest
quirkiest2234373quirkiest
saggiest102812723s_aggiest
sagiest82617993s_a_giest
saltiest83117723s_altiest
sandiest93218693s_andiest
sappiest122612583s_appiest
sarkier113413313s_arkie_r
sassiest83413623s_assiest
sauciest10310983s_auciest
savviest1435993s_avviest
scabbiest1534923scabbiest
scaliest101714403sca_liest
scantiest112611013scantiest
scarcest12169173scar_cest
scaredest1246633scaredest
scattiest11268373scattiest
scurfiest14236863scurfiest
scurviest14266123scurviest
seamiest102715423sea_miest
searest73322023sear__est
shabbiest1635333shabbiest
shadiest121711283sha_diest
shaggiest14156903shaggiest
shaliest111415063sha_liest
sharpest1339153shar_pest
sharpies13411233sharpies_
shirtiest1239333shirtiest
silkiest123212853s_ilkiest
skunkiest12135093skunkiest
slackest14289403slack_est
slaggiest11157713slaggiest
slangiest10129083slangiest
slatiest82616273sla_tiest
sleekiest1336073sleekiest
slinkiest13188083slinkiest
smartest10310183smar_test
smarties10312873smarties_
smeariest1138123smear_iest
smokiest1437883s_mokiest
snaggiest11126683snaggiest
snappiest1346503snappiest
snarkier12336513snarkie_r
snazziest1743143snazziest
sneakiest13176843sneakiest
soapiest102412853soa_piest
sorriest8413883s_orriest
spackles16319953spackles_
spangliest1345163spangliest
spareness1139863spareness
spares84834553spar__es_
sparges104016343spar_ges_
sparids103512123spar_ids_
sparked143513143spark_e_d
sparker133914363spark_e_r
sparkers144111313spark_ers
sparkily1735023sparki_ly
sparking152812543sparki_ng
sparkle133710213sparkle__
sparkled15317733sparkle_d
sparkler14317983sparkle_r
sparklers15315643sparklers
sparklier1554363sparklie_r
sparks124616363spark__s_
sparoids11218713sparoids_
sparrier10329143sparrie_r
spavies123012953spa_vies_
spaviet123011933spa_vie_t
speediest1257473speediest
spendiest1237533spendiest
spheriest1438383spheriest
spiciest122711613sp_iciest
spiffiest17235663spiffiest
spiniest102813233sp_iniest
splashiest1544473splashiest
splurgiest1343223splurgiest
spongiest1237093spongiest
spooniest11178143spooniest
spottiest11177693spottiest
sprawliest1543583sprawliest
sprucest12295783sp_rucest
spruciest1345153spruciest
spryest12247813sp_r_yest
spumiest1238213sp_umiest
spunkies14227593spunkies_
spurries102311323spurries_
staggiest11148263staggiest
stagiest91613413sta_giest
starchiest1547193starchiest
starkness1335963starkness
stickiest15229603stickiest
stinkiest13198463stinkiest
stockiest15207753stockiest
stormiest1137003stormiest
strawiest1237223strawiest
sturdiest10207393sturdiest
suckiest143314113s_uckiest
sugariest1038143sugar_iest
sulkiest124212503s_ulkiest
surfiest112414433s_urfiest
surliest82416913s_urliest
swampiest1635033swampiest
swankest15105933swank_est
swarthiest1644753swarthiest
swirliest1236293swirliest
tackiest143112433_tackiest
talkiest123611223_talkiest
tardiest93515243_tardiest
tarriest83215003_tarriest
tartiest82718313_tartiest
teariest82417263tear_iest
wackiest172610273_wackiest
wariest105122503_war_iest
wartiest113614643_wartiest
weariest112914793wear_iest
whackiest2144993whackiest

Search took 9 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 Limit1486412127.90618801.0
3Display Results2122120.0932279.6
 (SQL Overall)1786912128.43521184.5
 
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.