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

145 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
shoveled1519535(None) 
hoveled14209291_hoveled
shoveler14165581shoveler
shovelled16174411shovelled
groveled13345452groveled
hovelled15146842_hovelled
hovered143411572_hovered
shivered15177102shivered
shoaled113810962sho_aled
shooled115212652sho_oled
shoved134214272shov__ed
shovel124611312shovel__
shovelers15174942shovelers
shoveller15174542shoveller
shovels13378382shovel_s
showered1537012showered
shriveled1643152shriveled
sniveled1255462sniveled
swiveled1544162swiveled
beveled133811123_beveled
boweled132810693_boweled
chiseled1435883chiseled
chortled14326613chortled
clovered14187363clovered
covered133315293_covered
coveted133011523_coveted
develed123611933_develed
disheveled1842863disheveled
dovened12389063_dovened
doweled12269773_doweled
driveled1374973driveled
gaveled12399133_gaveled
graveled13417363graveled
groveler12305843groveler
grovelled1454183grovelled
havened14429243_havened
havered144011453_havered
heeled104018413_h_eeled
hobbled153310783_hobbled
holed95634133_ho__led
homered133212713_homered
hondled123510653_hondled
honeyed1437773_honeyed
hoovered15195413hoovered
hoppled15338083_hoppled
hoseyed1436953_hoseyed
hosteled1237283_hosteled
houseled1237283_houseled
hovel115017683_hovel__
hovels125413333_hovel_s
hoverer13319823_hoverer
howled134014963_ho_wled
leveled114010383_leveled
marveled1436433marveled
modeled1139453_modeled
overed102216623__overed
phoneyed1743843phoneyed
raveled114113633_raveled
reveled113917753_reveled
roweled11269863_roweled
schooled1447043scho_oled
scowled13398183sco_wled
seeled73922093s__eeled
severed113513863s_evered
shackled18277593shackled
shaled105023953sh__aled
shambled16156153shambled
shauled1148793sh_auled
shaved135118383shav__ed
shawled1437773sh_awled
sheened113511703sh_eened
sheered113515453sh_eered
sheeted113813033sh_eeted
shelled113815083sh_elled
shelved14379933sh__elved
shewed134716183sh__ewed
shield106212973sh_iel_d
shielded1334393sh_ielded
shilled113313623sh_illed
shingled13358313shingled
shiverer14186663shiverer
shoaler102610073sho_aler
shocked174611803sho_cked
shoed95723003sho___ed
shoeless1137803sho_eless
shogged13397953sho_gged
shooed103916073sho__oed
shopped153512203sho_pped
shored105723643sho__red
shoreless1236633shoreless
shorted113614393sho_rted
shortened1345663shortened
shotted113912383sho_tted
should1038023sho_ul_d
shouted113911543sho_uted
shove114421033shov__e_
shovelful1882163shovelful
shoveling1635553shoveling
shovellers16173783shovellers
shover124515983shov__er
shovers134612993shove_rs
shoves124919413shov__es
showed135016963sho__wed
showerer1436163showerer
shrewed14589843sh_rewed
shrieked16265173shrieked
shrieved15276073shrieved
shrilled1246863shrilled
shrivelled1742373shrivelled
shuffled18296233shuffled
shuttled1234663shuttled
silvered12237563silvered
skoaled12226043sko_aled
slavered12188033slavered
slivered12218103slivered
sniveler1155253sniveler
snivelled1353993snivelled
snooled84513933sno_oled
snoozled18344493snoozled
snorkeled1442873snorkeled
sobered102912433s_obered
soiled73822473s_o_iled
soled65835173s_o__led
souled75419823s_o_uled
sozzled16265183s_ozzled
speeled103712453s_peeled
spieled104811883s_pieled
spoiled104811353spo_iled
spooled104613523spo_oled
steeled83513213s_teeled
stoled74521593sto__led
stooled84313893sto_oled
stoppled1345003stoppled
storeyed1234643storeyed
streeled9267863streeled
subvened1436423subvened
surveyed1544233surveyed
swivelled1662963swivelled
tholed105113873tho__led
toweled112410223_toweled
traveled12349453traveled
troweled12106113troweled
wheeled14318463wh_eeled
whorled14366903who_rled
yodeled1236853_yodeled

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621459.47015434.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911459.68918442.7
 
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.