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 “shovelers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
shovelers1517494(None) 
shoveler14165581shoveler_
shovellers16173781shovellers
grovelers13305162grovelers
hoverers14289022_hoverers
shiverers15155772shiverers
shoeless1137802sho_eless
shoreless1236632shoreless
shoveled15195352shovele_d
shoveller15174542shoveller_
shovels13378392shovel__s
shovers134613002shov__ers
showerers1545072showerers
snivelers1264532snivelers
bevelers13389463_bevelers
chiselers1445453chiselers
cholers124215203cho__lers
chortlers14305663chortlers
coverers132712123_coverers
coveters132411083_coveters
drivelers1364223drivelers
groveler12305843groveler_
groveless13235363groveless
grovellers1443323grovellers
heelers103815633_h_eelers
hiveless14227933_hiveless
hobblers15308513_hobblers
holeless1189363_holeless
hollers103818233_ho_llers
homeless131110143_homeless
hopeless13118303_hopeless
hostelers1246643_hostelers
hostlers113310483_hostlers
hoteliers1245803_hoteliers
hoveled14209293_hovele_d
hovels125413343_hovel__s
hoverer13319823_hoverer_
hovers124320253_hov__ers
howlers133312353_ho_wlers
levelers11259323_levelers
loveless1168573_loveless
modelers1138463_modelers
moveless1367753_moveless
ravelers113310863_ravelers
revelers113414133_revelers
scoreless1155603scoreless
scowlers13257373sco_wlers
shacklers18336033shacklers
shadeless1335733shadeless
shameless1435923shameless
shapeless1435573shapeless
shavers134115093shav__ers
sheers94322403sh__e_ers
sheeters113111863sh_eeters
shellers112812583sh_ellers
shelters113412813sh__elters
shelvers14388813sh__elvers
shewers134312053sh__ewers
shielders1334763sh_ielders
shinglers13246443shinglers
shiverer14186663shiverer_
shivers133714833shiv__ers
shoaler102610083sho_aler_
shockers17319463sho_ckers
shoers94518333sho___ers
shooters112811583sho_oters
shoppers153010763sho_ppers
shorteners1345083shorteners
shoulders1334233shoulders
shouters113510623sho_uters
shovel124611323shovel___
shovelful1882163shovelful
shovelfuls1981483shovelfuls
shoveling1635553shoveling
shovelled16174413shovelled
shovelnose1651303shovelnose
shover124515993shov__er_
shoves124919423shov__e_s
showerer1436163showerer_
showerless1642543showerless
showers134612683sho__wers
shriekers16224423shriekers
shufflers18265153shufflers
shuttlers1254123shuttlers
silverers12215753silverers
slaverers12165993slaverers
sliverers12196363sliverers
smokeless1543553smokeless
sniveler1155253sniveler_
snivellers1352873snivellers
snorkelers1442273snorkelers
soleless8910033s_oleless
spielers10319653s_pielers
spoilers10238633spo_ilers
spoolers10349363spo_olers
stovers103713733stov__ers
travelers12266773travelers
trowelers12105263trowelers
wheelers14287743wh_eelers
yodelers1235673_yodelers

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.420425454.8
2DLD Change Limit1486411007.92318760.7
3Display Results1001000.0303333.3
 (SQL Overall)1786911008.37321341.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.