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

111 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
spheriest143838(None) 
sneeriest939312sneeriest
sparriest11198792sparriest
speediest1257472speediest
spheres123114352spher_es_
spherics1537072spherics_
spherier1337782spherie_r
spideriest1345292spideriest
spiriest102513462sp_iriest
spriest92718652sp__riest
aeriest73924053__aeriest
aperient10715153ap_erient
aperies9423203ap_eries_
aphorist13412513aphori_st
beeriest104013403_beeriest
chariest13315513_chariest
cheeriest1438213cheeriest
chertiest1438793_chertiest
chewiest16177293_chewiest
eeriest73620673__eeriest
fieriest112112243_fieriest
herbiest1339993__herbiest
leeriest83112883_leeriest
oneriest8313443_oneriest
orneriest947403orneriest
peeries93623023_peeries_
perkiest143313243_p_erkiest
pertest9317043_p_ertest
phoniest132811543_phoniest
priest84125423_p__riest
savoriest1246623savoriest
scariest101615953s_cariest
scarriest11188403scarriest
schiziest2343923schiziest
screwiest1445473screwiest
seediest92714053s_eediest
seepiest102412633s_eepiest
serest64831613s__er_est
series64540973s__eries_
severest11310323sever_est
sexiest142112223s__exiest
shadiest121711283s_hadiest
shakiest151910943s_hakiest
shaliest111415063s_haliest
sharpest1339153s_harpest
sheeniest12158363sheeniest
sheerest11310083s_heerest
shelliest1238033s_helliest
shelviest1535013s_helviest
sherbert1348793s_herbert
sherbet12311383s_herbe_t
sherbets1335213s_herbets
sherifs13299683s_herifs_
sherries111812893s_herries_
shiest95821533s_h__iest
shiniest113212503s_hiniest
shirtiest1239333s_hirtiest
shortest11310783s_hortest
showiest1438793s_howiest
sleekiest1336073sleekiest
sleepiest1136723sleepiest
sleetiest938563sleetiest
slipperiest1552403slipperiest
smeariest1138123smeariest
sneeziest1845153sneeziest
soberest10310353sober_est
sorriest8413883s_orriest
spaciest122310903sp_aciest
sparest94616433sp_ar_est
sparkiest15188103sparkiest
sparsest1048823sp_arsest
species11314133sp_ecies_
spendiest1237533spendiest
sphenes123013163sphe_nes_
sphere113313663spher_e__
sphered133512313spher_e_d
spheric14510073spheri__c
spherical1645803spherical
sphericity2053813sphericity
sphering142811943spheri_ng
spheroids1545543spheroids_
spherules1443823spherules_
spiceries1349313spiceries_
spiciest122711613sp_iciest
spiffiest17235663spiffiest
spikiest14259543sp_ikiest
spiniest102813233sp_iniest
spleeniest1264303spleeniest
splurgiest1343223splurgiest
spongiest1237093spongiest
spookiest15156403spookiest
spooniest11178143spooniest
sportiest111711033sportiest
spottiest11177693spottiest
spruciest1345153spruciest
spryest12247813sp__ryest
spumiest1238213sp_umiest
spunkiest15166573spunkiest
spurries102311323spurries_
starriest9159773starriest
steeliest939643steeliest
sternest8314433s_ternest
sugariest1038143sugariest
sultriest938653sultriest
summeriest1476083summeriest
superbest1349963superbest
sweepiest1435683sweepiest
thewiest14196343_thewiest
toweriest1246533toweriest
veriest103719133__veriest
wateriest12312233wateriest

Search took 7 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 Limit1486411116.47022973.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.93925751.7
 
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.