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_
shovels13378382shovel__s
shovers134612992shov__ers
showerers1545062showerers
snivelers1264532snivelers
bevelers13389453_bevelers
chiselers1445453chiselers
cholers124215193cho__lers
chortlers14305663chortlers
coverers132712123_coverers
coveters132411073_coveters
drivelers1364223drivelers
groveler12305843groveler_
groveless13235363groveless
grovellers1443323grovellers
heelers103815623_h_eelers
hiveless14227933_hiveless
hobblers15308513_hobblers
holeless1189363_holeless
hollers103818233_ho_llers
homeless131110133_homeless
hopeless13118303_hopeless
hostelers1246633_hostelers
hostlers113310483_hostlers
hoteliers1245803_hoteliers
hoveled14209293_hovele_d
hovels125413333_hovel__s
hoverer13319823_hoverer_
hovers124320253_hov__ers
howlers133312353_ho_wlers
levelers11259323_levelers
loveless1168573_loveless
modelers1138463_modelers
moveless1367753_moveless
ravelers113310863_ravelers
revelers113414133_revelers
scoreless1155603scoreless
scowlers13257343sco_wlers
shacklers18336033shacklers
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shavers134115093shav__ers
sheers94322403sh__e_ers
sheeters113111853sh_eeters
shellers112812563sh_ellers
shelters113412803sh__elters
shelvers14388813sh__elvers
shewers134312043sh__ewers
shielders1334753sh_ielders
shinglers13246433shinglers
shiverer14186663shiverer_
shivers133714833shiv__ers
shoaler102610073sho_aler_
shockers17319463sho_ckers
shoers94518323sho___ers
shooters112811553sho_oters
shoppers153010753sho_ppers
shorteners1345083shorteners
shoulders1334223shoulders
shouters113510593sho_uters
shovel124611313shovel___
shovelful1882163shovelful
shovelfuls1981483shovelfuls
shoveling1635553shoveling
shovelled16174413shovelled
shovelnose1651303shovelnose
shover124515983shov__er_
shoves124919413shov__e_s
showerer1436163showerer_
showerless1642543showerless
showers134612663sho__wers
shriekers16224423shriekers
shufflers18265143shufflers
shuttlers1254123shuttlers
silverers12215753silverers
slaverers12165993slaverers
sliverers12196363sliverers
smokeless1543553smokeless
sniveler1155253sniveler_
snivellers1352873snivellers
snorkelers1442273snorkelers
soleless8910033s_oleless
spielers10319643s_pielers
spoilers10238633spo_ilers
spoolers10349363spo_olers
stovers103713733stov__ers
travelers12266773travelers
trowelers12105253trowelers
wheelers14287733wh_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.1531167915.0
2DLD Change Limit1486411008.44017611.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911008.62320722.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.