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

120 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
flavored155457(None) 
favored1455981f_avored
flavorer1454551flavorer
flavoured1642971flavoured
clamored1336942clamored
clavered14187632clavered
favorer1355882f_avorer
favoured1533962f_avoured
flared105317602fla__red
flavone1335522flavone_
flavones1435832flavones
flavor1236662flavor__
flavorers1563982flavorers
flavors1337292flavor_s
flavory1644742flavor_y
floored11268682fl_oored
labored102810242_labored
savored1158342_savored
slavered12188032slavered
adored84714243__adored
avowed1335963__avowed
beavered1437503beavered
belabored1443813belabored
blared95018243bla__red
blazered2035063blazered
blazoned2044313blazoned
bravoed13436113bravo_ed
cavorted1435693_cavorted
clamorer1236903clamorer
clamoured1444073clamoured
clangored1343653clangored
clovered14187363clovered
enamored1147033enamored
factored1436213factored
fagoted1236073f_agoted
faired105915773f_a_ired
fallowed15127753fallowed
faltered122810983faltered
fared95842343f_a__red
favor114712453f_avor__
favorers1465493f_avorers
favors124211403f_avor_s
favourer1443823f_avourer
feared106320433fea__red
featured1237683featured
fevered14339723f_evered
flacked173711583fla_cked
flagged13459633fla_gged
flailed1137303fla_iled
flaked144715653fla__ked
flambeed16324383flambeed
flamed124618973fla__med
flammed15377413fla_mmed
flanged123810843fla_nged
flanked153710643fla_nked
flapped15328253fla_pped
flare84823633fla__re_
flares94521703fla__res
flashed144112183fla_shed
flatbed13397983fla_tbed
flatbread1542293flatbread
flatted114012943fla_tted
flattered13188623flattered
flaunted1234603flaunted
flavine1338453flavine_
flavines1437893flavines
flavonoid1651973flavonoid
flavonol1442213flavonol
flavorful1851713flavorful
flavoring1665113flavoring
flavorist1545453flavorist
flavorless1642183flavorless
flavorous1544253flavorous
flavour1334633flavo_ur
flavours1434693flavours
flavoury1743063flavoury
flawed134712723fla__wed
flaxseed1942573flaxseed
flayed134414053fla__yed
fleered11309503fl_eered
flooded12307933fl_ooded
floorer10248073fl_oorer
floret9321123fl__oret
florid10311453fl__orid
floured11289873fl_oured
flowed133513763fl__owed
flowered1546013flowered
fluorid1136783fl_uorid
frivoled1534043frivoled
glaired9387743gla_ired
glamoured1343183glamoured
glared84715193gla__red
havered144011453_havered
laborer9249503_laborer
laboured1156323_laboured
lagered92311153_lagered
laired75216813_la_ired
laved95028593_lav__ed
laveered1235253_laveered
layered11259413_layered
levered114212303_levered
livered113111633_livered
majored1735853_majored
palavered1543923palavered
quavered2144813quavered
razored1736333_razored
reavowed1534673reavowed
salvoed11307063salvo_ed
savorer1057883_savorer
savoured1234793_savoured
slalomed1134283slalomed
slaved104017043slav__ed
slaverer11196993slaverer
slivered12218103slivered
tabored102810563_tabored
unavowed1534783unavowed
unfavored1643443unfavored
unlabored1243803unlabored
vapored1336923_vapored
wavered142910433_wavered

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.423422437.4
2DLD Change Limit1461621206.67021913.3
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.13925030.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.