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

187 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
sparriest1119878(None) 
scarriest11188391scarriest
sparkiest15188091sparkiest
starriest9159761starriest
charriest1438252charriest
parries93925842_parries_
sarkiest123615062s_arkiest
scariest101615942sca_riest
smarmiest1335902smarmiest
snarkiest13207632snarkiest
snarliest91810202snarliest
sorriest8413882s_orriest
spaciest122310892spa_ciest
sparest94616422spa_r_est
sparkliest1644572sparkliest
sparrier10329142sparrie_r
sparsest1048812spa_rsest
spheriest1438372spheriest
spiriest102513452sp_iriest
sportiest111711022sportiest
spriest92718642sp__riest
spurries102311322spurries_
tarriest83215002_tarriest
aeriest73924053__aeriest
airiest74221013__airiest
arrest63722633__arr_est
artiest73121993__artiest
barkiest144115153_barkiest
barmiest125212783_barmiest
barniest104815053_barniest
blurriest1155153blurriest
burriest102911213_burriest
carries94328013_carries_
chariest13315503cha_riest
earliest82415243_earliest
firriest112310433_firriest
furriest112910793_furriest
gharries12318203gharries_
glairiest1035483glairiest
glariest92012523gla_riest
gnarliest10186553gnarliest
hairiest11612463_hairiest
hardiest123416333_hardiest
harries103525493_harries_
heartiest12311103heartiest
hoariest11312883hoa_riest
lardiest93813883_lardiest
larkiest123713313_larkiest
leariest83117843lea_riest
marliest102415183_marliest
marries93825283_marries_
merriest10311473_merriest
nearliest949363nearliest
paciest112917803_pa_ciest
paliest93021603_pa_liest
palliest102814633_palliest
palmiest123212023_palmiest
paltriest1138603_paltriest
pappiest112611113_pappiest
paries84742513_pa_ries_
parried103615723_parrie_d
parrier93717653_parrie_r
parriers103612903_parriers
parties93230863_parties_
pastiest103319543_pastiest
pawkiest17277883_pawkiest
pearliest1139353pearliest
perkiest143313243_perkiest
perries93226603_perries_
porkiest143513713_porkiest
porniest103214313_porniest
priest84125423_p__riest
pursiest102812123_pursiest
purtiest102414113_purtiest
quarries1749943quarries_
rearrest8311603rearr_est
sacrist9315423s_acri_st
saggiest102812713s_aggiest
sagiest82617983s_a_giest
saltiest83117713s_altiest
sandiest93218683s_andiest
sappiest122612573s_appiest
sassiest83413613s_assiest
sauciest10310973s_auciest
sauries72821623s_auries_
savoriest1246613savoriest
savviest1435983s_avviest
scabbiest1534913scabbiest
scaliest101714393sca_liest
scantiest112611003scantiest
scarcest12169173sca_rcest
scaredest1246633scaredest
scarrier10298453scarrie_r
scattiest11268363scattiest
scurfiest14236863scurfiest
scurries102911483scurries_
scurviest14266123scurviest
seamiest102715413sea_miest
searest73322023sea_r_est
serries73925353s_erries_
shabbiest1635323shabbiest
shadiest121711273sha_diest
shaggiest14156893shaggiest
shakiest151910933sha_kiest
shaliest111415053sha_liest
sharpest1339143sha_rpest
sharpies13411223sharpies_
sherries111812893sherries_
shirtiest1239323shirtiest
skankiest12145703skankiest
skerries12168673skerries_
slaggiest11157703slaggiest
slangiest10129073slangiest
slatiest82616263sla_tiest
slurries82710413slurries_
smartest10310183sma_rtest
smarties10312873smarties_
smeariest1138113smeariest
smirkiest1535193smirkiest
snaggiest11126673snaggiest
snakiest122110543sna_kiest
snappiest1346493snappiest
snazziest1743133snazziest
sneeriest939313sneeriest
soapiest102412843soa_piest
spangliest1345153spangliest
spareness1139863spareness
spareribs1353283spareribs_
spares84834553spa_r_es_
sparges104016343spa_rges_
sparids103512123spa_rids_
sparkier14298033sparkie_r
sparkish17276973sparki_sh
sparkles143210493sparkles_
sparklet143110593sparkle_t
sparklets15275843sparklets
sparoids11218713sparoids_
sparred104512863sparr_e_d
sparring113112223sparri_ng
sparrows1344803sparrows_
spavies123012943spa_vies_
spaviet123011923spa_vie_t
speediest1257463speediest
spendiest1237523spendiest
spiciest122711603sp_iciest
spideriest1345283spideriest
spiffiest17235653spiffiest
spikiest14259533sp_ikiest
spiniest102813223sp_iniest
splashiest1544463splashiest
splurgiest1343213splurgiest
spongiest1237083spongiest
spookiest15156393spookiest
spooniest11178133spooniest
spottiest11177683spottiest
sprawliest1543573sprawliest
sprucest12295783sp_rucest
spruciest1345143spruciest
spryest12247813sp__ryest
spumiest1238203sp_umiest
spunkiest15166563spunkiest
spurrier10297693spurrie_r
spurriers11245063spurriers
staggiest11148253staggiest
stagiest91613403sta_giest
stalkiest1347903stalkiest
starchiest1547183starchiest
starkest1239723sta_rkest
starrier8279463starrie_r
stormiest1137003stormiest
strawiest1237213strawiest
sturdiest10207393sturdiest
sugariest1038133sugariest
sultriest938653sultriest
surfiest112414433s_urfiest
surliest82416913s_urliest
swampiest1635023swampiest
swankiest16136203swankiest
swarthiest1644743swarthiest
swirliest1236293swirliest
tardiest93515243_tardiest
tarries73324263_tarries_
tartiest82718313_tartiest
teariest82417263tea_riest
wariest105122503_wa_riest
wartiest113614643_wartiest
weariest112914793wea_riest

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.453394461.4
2DLD Change Limit1486411876.75022020.9
3Display Results1871870.0802337.5
 (SQL Overall)1786911877.28324535.4
 
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.