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

132 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
skewered163421(None) 
sewered112911241s_ewered
severed113513862s_evered
sheered113515452she_ered
showered1537012showered
skeltered1443872skeltered
skewed145610232skew__ed
skewer13519612skewer__
skewers14498382skewer_s
sneered83113972sne_ered
speered103614812spe_ered
steered83615252ste_ered
answered1235493answered
bewared13310113_bewared
bowered133113043_bowered
cheered133713293che_ered
cowered133214653_cowered
dowered122811553_dowered
dyeweed1543203dyewe_ed
fevered14339723_fevered
fleered11309503fle_ered
flowered1546013flowered
glowered1345753glowered
jeered143912793_je_ered
jeweled1845333_jeweled
keeked104810123_ke_eked
keeled114414273_ke_eled
keened114013633_ke_ened
leered73816223_le_ered
levered114212303_levered
lowered112711913_lowered
metered103514013_metered
peered93819493_pe_ered
petered103314973_petered
pokeweed1842943pokewe_ed
powered132911643_powered
prewired14358473prewired
queered17117213que_ered
revered112819333_revered
rewired115413283_rewired
sabered103213023s_abered
saggered11237553saggered
sceptered1444723sceptered
sceptred1343653sceptred
scowdered1643743scowdered
seared75232843s_e_ared
seaweed11108813seawe_ed
seceded11319203s_eceded
secerned1136103s_ecerned
secured1059723s_ecured
seeded84520463s_e_eded
seeled73922093s_e_eled
seemed95117613s_e_emed
seeped94317523s_e_eped
sered65737293s___ered
severe94016083s_evere_
severer103511563s_everer
sewed95325163s_ew__ed
sewer84426223s_ewer__
sewers94719723s_ewer_s
sheared114516003she_ared
sheened113511703she_ened
sheerer103813843she_erer
sheeted113813043she_eted
sheltered1335573sheltered
shewbread1842043shewbread
shewed134716183shew__ed
shewer124515113shewer__
shewers134312053shewer_s
shivered15177103shivered
showerer1436163showerer
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sintered92213903sintered
sistered92612803sistered
skeed105018983sk__e_ed
skeeter113410413ske_eter
skeined1236773ske_ined
skelped1435203ske_lped
sketched1835393sketched
skewbald1842073skewbald
skewering1744633skewering
skippered1843433skippered
skirred12347083sk_irred
skittered1434633skittered
skyward1843863skywar_d
slavered12188033slavered
sleeked123510883sle_eked
sleeted83113223sle_eted
sleeved11419913sle_eved
slewed104815523slew__ed
slivered12218103slivered
smeared104510623sme_ared
smeeked14287223sme_eked
snakeweed1742283snakewe_ed
sneakered1443713sneakered
sneerer73512313sne_erer
sneezed17287793sne_ezed
sobered102912433s_obered
soldered1038153soldered
speared104314423spe_ared
speeded113310423spe_eded
speeled103712453spe_eled
speired103811103spe_ired
spewed125512333spew__ed
spewer115112153spewer__
spewers124210663spewer_s
sphered133512313s_phered
spiered104412463s_piered
steamered1244913steamered
steeked124010473ste_eked
steeled83513213ste_eled
steeped103412283ste_eped
steerer73113633ste_erer
steeved113610133ste_eved
stereoed937883stereoed
steward1138063stewar_d
stewarded1443533stewarded
stewed104814243stew__ed
suckered1537833suckered
suffered1536733suffered
summered1338143summered
sundered10312153sundered
supered10316123s_upered
sweltered1344453sweltered
swerved1455703s__werved
syphered1755013syphered
teetered9258303teetered
towered112911403_towered
veered103612743_ve_ered
weeweed1435183weewe_ed

Search took 8 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.420425454.8
2DLD Change Limit1461621326.58022213.1
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.04625360.6
 
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.