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

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

88 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
shepherding215227(None) 
sheepherding2251891sheepherding
sheepherdings2361252sheepherdings
sceptering1545793scepter_ing
sheering123715103she__er_ing
sheltering1446493shelter_ing
shepherd1744373shepherd___
shepherded2052263shepherd_ed
shepherdess2051413shepherdess
shepherds1843223shepherd__s
sphering142811943s__pher_ing
syphering18175733s_ypher_ing
beheading1636164_be_heading
blethering16115934blether_ing
chaptering18107964chapter_ing
checkering2244404checker_ing
cheering143612704che__er_ing
chequering2543124chequer_ing
chippering2045164chipper_ing
choppering2064814chopper_ing
ciphering17217704_cipher_ing
cyphering20175244_cypher_ing
depending14208784_dep_ending
deperming1537114_dep_erming
ensphering1644974enspher_ing
ephedrin1444704__ephedrin_
ephedrine1544384__ephedrine
ephedrins1544154__ephedrins
heeding123515064_he__e_ding
herding122915124____herding
hyphening2144144_hyphe_ning
insphering1644194inspher_ing
lechering1538444_lecher_ing
peppering1337084_pepper_ing
reperking1638704_rep_erking
repleading1436624_repleading
sceptring1444274scep_tr_ing
scuppering1754024scupper_ing
seceding12288564s_e_ce_ding
secerning1246204s_e_cerning
seeding93719484s_e__e_ding
severing122013854s_e_ver_ing
sewering122411094s_e_wer_ing
shattering1498284shatter_ing
shearing123915904she__ar_ing
shearling1336924she__arling
shedding14278114s___hedding
sheening123010804she__e_ning
sheepherder2061884sheepherd_er
sheepherders2181634sheepherders
sheepshearing2261334sheepshearing
sheeting122712834she__e_ting
shending132511254s___hending
shielding1434554sh__ielding
shimmering1884624shimmer_ing
shivering1637334sh_iver_ing
shoehorning1851734shoehorning
showering1646404sh_ower_ing
shredding1544514sh__redding
shuddering1643514shudder_ing
shuttering1496564shutter_ing
simpering1449294simp_er_ing
skeltering1545004skelter_ing
skewering1744634ske_wer_ing
skippering1943674skipper_ing
slathering14108284slather_ing
slithering1496894slither_ing
smothering1646014smother_ing
sneering93414504sne__er_ing
spearheading1951864spearheading
speeding122810934s__p_eeding
speering113116324s__peer_ing
spending122712434s__p_ending
spiering112713354s__pier_ing
spreading1339654s__preading
steamering1345444steamer_ing
steering93916794ste__er_ing
stewarding1543524ste_warding
stoppering1544614stopper_ing
subheading1743794s_ubheading
sulphuring1642774sulphur_ing
supering11317684s_up_er_ing
suspending1445034susp_ending
sweltering1445234swelter_ing
swithering17105214swither_ing
telphering1644204telpher_ing
tethering1339134_tether_ing
unsphering1644284unspher_ing

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819889.31315979.7
3Display Results88880.0461913.0
 (SQL Overall)178691889.78218267.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.