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

170 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
favorers146549(None) 
favorer1355881favorer_
favourers1543121favourers
flavorers1563981flavorers
savorers1157221savorers
adorers84411732_adorers
avowers1336332_avowers
cavorters1434972cavorters
fagoters1234862fagoters
farers95924052fa__rers
favored1455982favore_d
favors124211402favo__rs
favourer1443822favourer_
favours13437092favo_urs
flavorer1454562flavorer_
floorers11227572floorers
laborers10208382laborers
savorer1057882savorer_
savourers1243832savourers
taborers10268332taborers
vaporers1336242vaporers
waverers14318612waverers
aborters1038573_aborters
adorer74713453_adorer_
adores74420723_adore_s
adorners9196623_adorners
airers64922313_a_irers
armorers10288973armorers
atoners75013963_atoners
avers85127313_av__ers
averters11249513_averters
avocets1235453_avocets
avoiders1254793_avoiders
avosets1036663_avosets
avower1236823_avower_
borers85122683__borers
cajolers17267133cajolers
caloyers1337343caloyers
canoers94318373cano_ers
caperers122611723caperers
carers85133963ca__rers
carolers103314173carolers
caterers102814413caterers
cavers115026843cav__ers
cavilers1348113cavilers
cavorter1335783cavorter_
cavorts1237933cavor_ts
clamorers1345783clamorers
colorers10312183colorers
corers85231073__corers
coverers132712123coverers
darers75921873da__rers
devourers1344093devourers
divorcers1543693divorcers
evokers14386793_evokers
fablers124812613fa_blers
facers115519443fa__cers
faders105117463fa__ders
fagoter1135883fagoter_
fainters11349693fainters
fairer95212063fa_irer_
fakeers14446673fa_keers
fakers134219533fa__kers
falconers1445323falconers
fallers103917993fa_llers
falterers12238043falterers
falters103916473fa_lters
fanciers13358083fanciers
fanners103914653fa_nners
farcers124713443fa_rcers
farer86733143fa__rer_
fares85852873fa__re_s
farmers124315263fa_rmers
farriers113610743farriers
fathers133916503fa_thers
fathomers1744953fathomers
faves115331423fav__e_s
favor114712453favo__r_
favoring1596673favoring
favorite1447313favorite
favorites1546583favorites
favour12438333favo_ur_
favoured1533963favoure_d
favuses1336183favuse_s
fawners13388493fa_wners
fearers104815273f_earers
fevers125414893fev__ers
figurers12254873figurers
firers94922683f__irers
fivers124420923fiv__ers
flavones1435833flavone_s
flavored1554583flavore_d
flavorless1642183flavorless
flavorous1544253flavorous
flavors1337293flavo__rs
flavours1434693flavo_urs
flooders12257833flooders
floorer10248073floorer_
florets1039853f_lorets
flowers133413173f_lowers
flyovers1733673flyovers
footers104618333f_ooters
forcers124215713f__orcers
fores85847103f__ore_s
forgers115218183f__orgers
forkers144615783f__orkers
formers128217953f__ormers
foyers125413133f__oyers
frivolers1543473frivolers
fuehrers1442613fuehrers
fuhrers1334813f_uhrers
furores10310033furore_s
galores82614343galore_s
gaolers83511563ga_olers
harborers1446913harborers
haverels14325753haverels
havers124721483hav__ers
havockers2142123havockers
honorers1139273honorers
hoverers14289023hoverers
ignorers9215243ignorers
invokers1534673invokers
laborer9249513laborer_
labourers1144713labourers
laveers10329363lav_eers
lavers94526363lav__ers
layovers1434073layovers
manurers1037593manurers
marrers93414313ma_rrers
maturers1037383maturers
mayoress1344383mayoress
paperers122410453paperers
parers85530743pa__rers
pavers115021823pav__ers
pavisers13387443pavisers
quaverers2143853quaverers
ravagers1235583ravagers
ravelers113310863ravelers
raveners11309133raveners
ravers94628183rav__ers
reverers113113153reverers
revokers15366753revokers
savers93825923sav__ers
savored1158343savore_d
savorier1136643savorier_
savories11311273savories
savorless1243213savorless
savorous1146603savorous
savors95616103savo__rs
savourer1134473savourer_
savours10389343savo_urs
scorers94115323_scorers
slaverers12165993slaverers
snorers74313803_snorers
storers75018683_storers
taborer9269293taborer_
taborets10278073taborets
tabourers1144673tabourers
taperers10269773taperers
taverners1244273taverners
vaporer1236983vaporer_
vapourers1443373vapourers
vomers115614943__vomers
voters95017443__voters
vowers124317183__vowers
wagerers12247613wagerers
wagoners1235473wagoners
waterers112312793waterers
waverer13319523waverer_
wavers125022483wav__ers

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.453394461.4
2DLD Change Limit1461621707.15620425.1
3Display Results1701700.0802125.0
 (SQL Overall)1786911707.68923239.8
 
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.